DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on PO_RELEASES_ALL

Line 3294: ,po_releases_all pra

3290: ,mtl_system_items_vl item_v
3291: ,po_lines_all pl
3292: ,pa_projects_all prj
3293: ,pa_tasks task
3294: ,po_releases_all pra
3295: ,jmf_shikyu_replenishments jsr
3296: ,oe_order_lines_all oola
3297: ,oe_order_headers_all ooha
3298: ,jmf_shikyu_allocations jsa

Line 3302: ,po_releases_all pra_s

3298: ,jmf_shikyu_allocations jsa
3299: ,po_line_locations_all plla_s
3300: ,po_headers_all pha_s
3301: ,po_lines_all pla_s
3302: ,po_releases_all pra_s
3303: ,cst_item_costs cic
3304: WHERE cfr_mid.row_type = CFR_TMP_RCV_ROW
3305: AND cfr_mid.oem_inv_org_id = mp_oem.organization_id
3306: AND cfr_mid.tp_inv_org_id = mp_tp.organization_id

Line 3758: ,po_releases_all pra_s

3754: ,oe_order_headers_all ooha
3755: ,po_line_locations_all plla_s
3756: ,po_headers_all pha_s
3757: ,po_lines_all pla_s
3758: ,po_releases_all pra_s
3759: ,wip_requirement_operations wro
3760: ,MTL_SYSTEM_ITEMS_B_KFV msibk
3761: ,rcv_transactions rt
3762: --Added to get task start

Line 3919: ,po_releases_all pra

3915: FROM oe_order_lines_all oola
3916: ,oe_order_headers_all ooha
3917: ,po_line_locations_all plla
3918: ,po_lines_all pla
3919: ,po_releases_all pra
3920: ,po_headers_all pha
3921: ,jmf_shikyu_replenishments jsr
3922: ,hr_organization_information hoi
3923: -- Amy added to fix bug 5583680 start

Line 4091: ,po_releases_all pra

4087: FROM oe_order_lines_all oola
4088: ,oe_order_headers_all ooha
4089: ,po_line_locations_all plla
4090: ,po_lines_all pla
4091: ,po_releases_all pra
4092: ,po_headers_all pha
4093: ,jmf_shikyu_replenishments jsr
4094: ,hr_organization_information hoi
4095: WHERE oola.header_id = ooha.header_id