Query to get dependencies on an object

SELECT DISTINCT a.referenced_name main_parent, a.NAME main_child,b.referenced_name next_level_parent, b.NAME next_level_child
FROM all_dependencies a, all_dependencies b
WHERE 1 = 1
AND b.referenced_name = a.NAME
AND a.referenced_name IN('YYY_CIB_FLAGS_AGV','YYY_CIB_AGV','YYY_SLA_HOURS_AGV','YYY_SPL_PARTS_AGV')
ORDER BY 1, 3

Consigned Inventory Flow in R12

Source

Consigned Inventory Flow in R12

Setup steps

Step 1) Create an Item "CONSIGNED". Apply Purchasing template. Also tick "Use Approved Supplier" in purchasing tab

Step 2) Create a Blanket Purchase Agreement for this item. Take supplier as "Abbott Laboratories, Inc." and site as "CORP HQ". Make sure pay on "Use" is ticked in Supplier setups

Step 3) Create an ASL for this Item and Supplier combination. On Item-attributes form assign above blanket Agreement and  in Inventory tab tick the Consigned from Supplier.

Step 4) Define Consigned\VMI Consumption rules in inventory. Navigate to Setup>Transactions>Consigned\VMI Consumption. Here take From Sub-inventory as "Stores" and To Sub-inventory as "FGI"

Note : The weight value allows you to set the processing order. For example, if two transactions satisfy the transaction criteria, the system processes the transaction with the highest weight.

Test Case

Step 1) Create a Standard PO and Receive the material. Please keep receipt routing as Direct

You can notice Consigned flag on Shipment line is checked automatically. All consigned PO is always closed for invoicing

Step 2) Now go to iSupplier Portal and create an ASN for this PO 6356

ASN1234

Step 3) Now receive against this ASN

Step 4) You can check that no accounting transactions created yet

Step 5) Check owning party information

Step 6) Now when we require material we can transfer material from Stores to FGI. Transfer 10 qty

Step 7) Check Material transactions

Step 8) Now run Consumption Advise

Step 9) Now check the consumption advise from the po summary form. consumption advice create a release against the BPA we have created in setup steps. Remember the BPA number was 6355.

You can see you can not open the release i.e. you can not modify the consumption advise. also this release is closed for receiving as material is already received

Step 10) Now log in iSupplier to see consumption advice

You can click on consumption advise and see it

Devyaa Aartikyam

DURGA_SAPTASHATI_PATH

Alikul komal baale dhrut moutik maale Stan yug nirjit taale kshiraam-budhi baale Kaashmira-ankit bhaale naashit bhav jaale Lilaa mardit kote sharanaagat paale

Jay Devi jay Devi jay maatah kamale Drut jaambu nad vimale sur nut pad kamale Jay Devi jay Devi

Kamal dalaayat nayane shashi nibh shubh vasane Simha viraajit gamane hiraavali radane Muni jan virchit namane krut raakshash kadane Kokil manjul gadane Vishnu-rah sadane II Jay Devi…II

Naag-aadi ankit mastak bhuvan-aavan sakte Praashan bhaajan khet-aadi-aayudh kar yukte Krut kar vir nivaase ripu mardan sakte Shuk naashaa samanaase taarit nij bhakte II Jay Devi…II

Adhar vinir-jit bimbe vishva stut rupe Pruthu-tar chaaru nitambe krut daanav kope Bhru jit manmath chaape nij jan hrut taape Daaji jyotir vidvaan prana-mati hrut taape II Jay Devi…II

Why i am not able to float easily

1. The distribution of body tissues on a unique physical structure causes each individual to float differently. When adipose tissue is concentrated more in one part of the body (e.g., around the thighs and hips of "pear-shaped" women) the center of buoyancy moves closer to the center of gravity reducing the rotational sinking effect in the lower part of the swimmer. Such individuals would need to devote less effort to force production to streamline the total shape. Conversely, swimmers with very little fat below the center of gravity, but with some above, will sink markedly. They will need to work harder with kicking to maintain streamliSourcene while swimming.

Conversion Strategy

PO


This conversion is from one inventory organization to another inventory organization

We create a new line with the outstanding quantity and cancel the earlier line.
 This will close the old line for receiving but the line will still be open for invoicing.


Where the quantity billed is less than the quantity received. : No issues. Invoice can still be matched

Where the quantity billed is more than the quantity received. :
Unmatch the invoice before conversion and match it after conversion.

Back Order

Order Management and Shipping Execution has two types of   Backorders.

Back-orders caused by Pick Releasing (PR)  order lines when there is no or not enough stock available.

And back-orders caused by shipping less, at Ship confirm, than what was released.



A. Backorders after Pick Releasing with Insufficient Stock

Pick Release will process all order (more correctly shipping) lines that you selected when
submitting PR.  It will create move order lines for each line, whether there is stock available or not.
You (or the system) will however, not be able to (auto) detail and (auto) Pick Confirm the    
lines where there is not enough stock available.  In R11i, you cannot switch off reservations
for PR.  Also, the system will not print pick slips for lines that are not detailed.

 

The delivery line, which was 'Ready to Release' before running PR will be split into a quantity
 that was available for picking and a unavailable quantity.  The first delivery line will become
status ‘Released’ (Pick Confirmed), the second 'Submitted for Release' (Move Order created,
but not confirmed).  In the latter case, the ‘Details Required' status is checked.  The order line will
 not split at this point, but receives a 'Picked partial' status.  After Ship Confirming the Released
delivery line, the original order line will be split into a 'Shipped' and a 'Submitted for Release' line
 (unless the shipped quantity falls within the under shipment tolerance).  The latter will be available
 for Pick Release as a 'Backorder' as soon as there is stock available.  On the sales order, there is
no order or workflow status called 'Backorder'.  You will not really see any difference
between a scheduled order line that was never released and a backordered line.  
Pick Release is able to distinguish between the two, because it allows you to release them
separately.

B. Backorders Caused by shipping less than what was Released

Before Ship Confirming a Released (Pick Confirmed) delivery line, you have theoption to update the 

shipped quantity.  If the shipped quantity is less than the picked quantity, you have can either 

designate the remaining quantity as

'Backordered' (meaning the quantity was lost somewhere along the picking/staging process) or 

leave it in staging in to assign it to a different delivery (i.e. truck was full and wait for next pick up).

At Ship Confirm, any staged quantities will be split off in a separate delivery line that is

immediately ready to be shipped in a subsequent delivery.  A backordered quantity will remain 

noted on the same delivery line.  Only when the original delivery line is interfaced through       

Inventory Interface/Order Management Interface, will the order line be split into a line for the 

shipped quantity and a new line for the backordered quantity (Awaiting shipping).  This enables 

you to pick the remaining quantity again in order to fulfill the complete order quantity.  This split 

will only happen if the backordered quantity is greater than the Under Shipment Tolerance.

Order Management Flows and Workflow Status

Source