APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on PO_LINES_ALL

Line 1330: ,po_lines_all pla

1326: ,p_oem_inv_org_id
1327: ,p_tp_inv_org_id
1328: ,p_item_id
1329: FROM po_headers_all pha
1330: ,po_lines_all pla
1331: ,po_line_locations_all plla
1332: ,MTL_UNITS_OF_MEASURE_TL uom_tl
1333: ,HR_ORGANIZATION_INFORMATION hoi -- Add this table to get information of oem
1334: WHERE pla.po_header_id = pha.po_header_id

Line 3019: --step1: get crude data: add the data for standard po, using po_lines_all

3015: );
3016: -- **** for debug information in readonly UT environment.--- end ****
3017:
3018:
3019: --step1: get crude data: add the data for standard po, using po_lines_all
3020: rpt_get_crude_data(p_rpt_mode => p_rpt_mode
3021: ,p_currency_conversion_type => p_currency_conversion_type
3022: ,p_currency_conversion_date => l_p_currency_conversion_date
3023: ,p_functional_currency => p_functional_currency);

Line 3291: ,po_lines_all pl

3287: ,po_vendor_sites_all pvs
3288: ,po_headers_all ph
3289: ,po_vendor_contacts pvc
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

Line 3301: ,po_lines_all pla_s

3297: ,oe_order_headers_all ooha
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

Line 3757: ,po_lines_all pla_s

3753: ,oe_order_lines_all oola
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

Line 3918: ,po_lines_all pla

3914: ,plla.promised_date) expected_rcv_date
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

Line 4090: ,po_lines_all pla

4086: ,plla.promised_date) expected_rcv_date
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