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 3760: ,po_lines_all pla_s

3756: ,oe_order_lines_all oola
3757: ,oe_order_headers_all ooha
3758: ,po_line_locations_all plla_s
3759: ,po_headers_all pha_s
3760: ,po_lines_all pla_s
3761: ,po_releases_all pra_s
3762: ,wip_requirement_operations wro
3763: ,MTL_SYSTEM_ITEMS_B_KFV msibk
3764: ,rcv_transactions rt

Line 3921: ,po_lines_all pla

3917: ,plla.promised_date) expected_rcv_date
3918: FROM oe_order_lines_all oola
3919: ,oe_order_headers_all ooha
3920: ,po_line_locations_all plla
3921: ,po_lines_all pla
3922: ,po_releases_all pra
3923: ,po_headers_all pha
3924: ,jmf_shikyu_replenishments jsr
3925: ,hr_organization_information hoi

Line 4093: ,po_lines_all pla

4089: ,plla.promised_date) expected_rcv_date
4090: FROM oe_order_lines_all oola
4091: ,oe_order_headers_all ooha
4092: ,po_line_locations_all plla
4093: ,po_lines_all pla
4094: ,po_releases_all pra
4095: ,po_headers_all pha
4096: ,jmf_shikyu_replenishments jsr
4097: ,hr_organization_information hoi