APPS.CSTPPIPV dependencies on WIP_DISCRETE_JOBS

Line 781: wip_discrete_jobs wdj

777: FROM po_distributions_all pda,
778: po_line_locations_all plla,
779: po_lines_all pla,
780: wip_entities we,
781: wip_discrete_jobs wdj
782: WHERE ( ( ( p_item_type = 1 -- OSP and direct
783: OR p_item_type = 2) -- OSP only
784: AND ( ( l_item_option = 1 -- All items
785: AND EXISTS (

Line 867: wip_discrete_jobs wdj,

863: cursor c_po_dists2 is
864: SELECT pda.po_distribution_id
865: FROM po_distributions_all pda,
866: wip_entities we,
867: wip_discrete_jobs wdj,
868: wip_operation_resources wor
869: WHERE we.wip_entity_id = pda.wip_entity_id
870: AND we.entity_type = 6
871: AND wdj.wip_entity_id = pda.wip_entity_id

Line 2140: wip_discrete_jobs wdj

2136: wdj.date_released+0.00001,
2137: rt.transaction_date))
2138: INTO l_transaction_date
2139: FROM rcv_transactions rt,
2140: wip_discrete_jobs wdj
2141: WHERE rt.wip_entity_id = wdj.wip_entity_id (+)
2142: AND rt.transaction_type = 'DELIVER'
2143: AND rt.po_distribution_id = p_po_distribution_id
2144: AND rt.transaction_date = (

Line 2167: wip_discrete_jobs wdj

2163: rt.transaction_date))
2164: INTO l_transaction_date
2165: FROM rcv_transactions rt,
2166: po_distributions_all pda,
2167: wip_discrete_jobs wdj
2168: WHERE pda.wip_entity_id = wdj.wip_entity_id (+)
2169: AND pda.po_distribution_id = p_po_distribution_id
2170: AND rt.transaction_type = 'RECEIVE'
2171: AND ( rt.po_distribution_id = p_po_distribution_id