APPS.JMF_SHIKYU_INV_PVT dependencies on JMF_SUBCONTRACT_ORDERS

Line 108: FROM JMF_SUBCONTRACT_ORDERS

104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: SELECT OSA_ITEM_ID
107: INTO l_osa_item_id
108: FROM JMF_SUBCONTRACT_ORDERS
109: WHERE SUBCONTRACT_PO_SHIPMENT_ID = p_subcontract_po_shipment_id
110: AND ROWNUM = 1;
111:
112: Process_Transaction

Line 179: FROM JMF_SUBCONTRACT_ORDERS

175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: SELECT OSA_ITEM_ID
178: INTO l_osa_item_id
179: FROM JMF_SUBCONTRACT_ORDERS
180: WHERE SUBCONTRACT_PO_SHIPMENT_ID = p_subcontract_po_shipment_id
181: AND ROWNUM = 1;
182:
183: Process_Transaction

Line 249: FROM JMF_SUBCONTRACT_ORDERS

245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: SELECT OSA_ITEM_ID
248: INTO l_osa_item_id
249: FROM JMF_SUBCONTRACT_ORDERS
250: WHERE SUBCONTRACT_PO_SHIPMENT_ID = p_subcontract_po_shipment_id
251: AND ROWNUM = 1;
252:
253: Process_Transaction

Line 319: FROM JMF_SUBCONTRACT_ORDERS

315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316:
317: SELECT OSA_ITEM_ID
318: INTO l_osa_item_id
319: FROM JMF_SUBCONTRACT_ORDERS
320: WHERE SUBCONTRACT_PO_SHIPMENT_ID = p_subcontract_po_shipment_id
321: AND ROWNUM = 1;
322:
323: Process_Transaction

Line 530: FROM jmf_subcontract_orders

526:
527: BEGIN
528: SELECT tp_organization_id
529: INTO l_organization_id
530: FROM jmf_subcontract_orders
531: WHERE subcontract_po_shipment_id = p_subcontract_po_shipment_id;
532:
533: l_primary_uom:= JMF_SHIKYU_UTIL.Get_Primary_UOM_Code
534: ( p_item_id , l_organization_id);

Line 563: jmf_subcontract_orders jso

559: wro.supply_locator_id
560: INTO l_subinventory_code,
561: l_locator_id
562: FROM wip_requirement_operations wro,
563: jmf_subcontract_orders jso
564: WHERE wro.wip_entity_id = jso.wip_entity_id
565: AND wro.inventory_item_id = p_item_id
566: AND wro.organization_id = jso.tp_organization_id
567: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id;

Line 579: jmf_subcontract_orders jso

575:
576: SELECT wro.supply_locator_id
577: INTO l_locator_id
578: FROM WIP_REQUIREMENT_OPERATIONS wro,
579: jmf_subcontract_orders jso
580: WHERE wro.wip_entity_id = jso.wip_entity_id
581: AND wro.organization_id = jso.tp_organization_id
582: AND wro.ORGANIZATION_ID = l_organization_id
583: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id

Line 620: , jmf_subcontract_orders jso

616: THEN
617: SELECT wdj.wip_entity_id
618: INTO l_wip_entity_id
619: FROM wip_discrete_jobs wdj
620: , jmf_subcontract_orders jso
621: WHERE jso.wip_entity_id = wdj.wip_entity_id
622: AND jso.tp_organization_id = wdj.organization_id
623: AND wdj.organization_id = l_organization_id
624: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id;