APPS.CSTPPIPV dependencies on WIP_DISCRETE_JOBS

Line 805: wip_discrete_jobs wdj

801: FROM po_distributions_all pda,
802: po_line_locations_all plla,
803: po_lines_all pla,
804: wip_entities we,
805: wip_discrete_jobs wdj
806: WHERE ( ( ( p_item_type = 1 -- OSP and direct
807: OR p_item_type = 2) -- OSP only
808: AND ( ( l_item_option = 1 -- All items
809: AND EXISTS (

Line 891: wip_discrete_jobs wdj,

887: cursor c_po_dists2 is
888: SELECT pda.po_distribution_id
889: FROM po_distributions_all pda,
890: wip_entities we,
891: wip_discrete_jobs wdj,
892: wip_operation_resources wor
893: WHERE we.wip_entity_id = pda.wip_entity_id
894: AND we.entity_type = 6
895: AND wdj.wip_entity_id = pda.wip_entity_id

Line 2226: wip_discrete_jobs wdj

2222: wdj.date_released+0.00001,
2223: rt.transaction_date))
2224: INTO l_transaction_date
2225: FROM rcv_transactions rt,
2226: wip_discrete_jobs wdj
2227: WHERE rt.wip_entity_id = wdj.wip_entity_id (+)
2228: AND rt.transaction_type = 'DELIVER'
2229: AND rt.po_distribution_id = p_po_distribution_id
2230: AND rt.transaction_date = (

Line 2253: wip_discrete_jobs wdj

2249: rt.transaction_date))
2250: INTO l_transaction_date
2251: FROM rcv_transactions rt,
2252: po_distributions_all pda,
2253: wip_discrete_jobs wdj
2254: WHERE pda.wip_entity_id = wdj.wip_entity_id (+)
2255: AND pda.po_distribution_id = p_po_distribution_id
2256: AND rt.transaction_type = 'RECEIVE'
2257: AND ( rt.po_distribution_id = p_po_distribution_id