eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INL_INTEGRATION_GRP dependencies on PO_HEADERS

Line 2918: FROM po_headers_all ph,

2914: pll.amount,
2915: pll.value_basis,
2916: pll.matching_basis,
2917: 'Y' lcm_flag
2918: FROM po_headers_all ph,
2919: po_lines_all pl,
2920: po_line_locations_all pll,
2921: po_releases_all pr -- Bug 9734841
2922: WHERE ph.po_header_id = p_po_header_id

Line 3105: l_lci_table(l_ind_lci).hdr_interface_source_table := 'PO_HEADERS';

3101: l_lci_table(l_ind_lci).shipment_header_id := p_po_hdr_rec.po_header_id;
3102: l_lci_table(l_ind_lci).transaction_type := 'CREATE';
3103: l_lci_table(l_ind_lci).processing_status_code := 'PENDING';
3104: l_lci_table(l_ind_lci).interface_source_code := 'PO';
3105: l_lci_table(l_ind_lci).hdr_interface_source_table := 'PO_HEADERS';
3106: l_lci_table(l_ind_lci).validation_flag := 'N';
3107: l_lci_table(l_ind_lci).rcv_enabled_flag := 'N';
3108: l_lci_table(l_ind_lci).last_task_code := l_last_task_code;
3109: l_lci_table(l_ind_lci).processing_status_code := 'PENDING';

Line 3557: FROM po_headers_all ph,

3553: l_po_hdr_rec.org_id, -- 09
3554: l_po_hdr_rec.approved_date, -- 10
3555: l_simulation_rec.freight_code, -- 11
3556: l_simulation_rec.org_id -- 12
3557: FROM po_headers_all ph,
3558: po_releases_all pr
3559: WHERE ph.po_header_id = pr.po_header_id
3560: AND pr.po_release_id = p_po_release_id;
3561:

Line 3564: l_simulation_rec.parent_table_name := 'PO_HEADERS';

3560: AND pr.po_release_id = p_po_release_id;
3561:
3562: ELSE
3563:
3564: l_simulation_rec.parent_table_name := 'PO_HEADERS';
3565: l_simulation_rec.parent_table_id := p_po_header_id;
3566:
3567:
3568:

Line 3571: p_debug_info => 'Get data from PO HEADERS');

3567:
3568:
3569: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
3570: p_procedure_name => l_api_name,
3571: p_debug_info => 'Get data from PO HEADERS');
3572:
3573: SELECT ph.po_header_id, -- 01
3574: ph.segment1, -- 02
3575: ph.vendor_id, -- 03

Line 3600: FROM po_headers_all ph

3596: l_po_hdr_rec.org_id, -- 10
3597: l_po_hdr_rec.approved_date, -- 11
3598: l_simulation_rec.freight_code, -- 12
3599: l_simulation_rec.org_id -- 13
3600: FROM po_headers_all ph
3601: WHERE po_header_id = p_po_header_id;
3602: END IF;
3603:
3604: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

Line 3675: -- l_simulation_rec.parent_table_name := 'PO_HEADERS'; -- Bug 14280113

3671: p_debug_info => 'Call INL_SIMULATION_PVT.Create_Simulation');
3672:
3673: -- Format data to create simulation
3674: l_simulation_rec.firmed_flag := 'N';
3675: -- l_simulation_rec.parent_table_name := 'PO_HEADERS'; -- Bug 14280113
3676:
3677: INL_SIMULATION_PVT.Create_Simulation(p_api_version => 1.0,
3678: p_init_msg_list => FND_API.G_FALSE,
3679: p_commit => FND_API.G_FALSE,

Line 3819: po_headers ph,

3815: pl.line_num,
3816: ph.segment1
3817: FROM po_line_locations pll,
3818: po_lines pl,
3819: po_headers ph,
3820: inl_simulations s
3821: WHERE INV_UTILITIES.inv_check_lcm(
3822: pl.item_id,
3823: pll.ship_to_organization_id,

Line 3832: AND s.parent_table_name = 'PO_HEADERS'

3828: AND ph.po_header_id = pl.po_header_id
3829: AND pll.po_header_id = pl.po_header_id
3830: AND pll.po_line_id = pl.po_line_id
3831: AND pl.po_header_id = s.parent_table_id
3832: AND s.parent_table_name = 'PO_HEADERS'
3833: AND s.simulation_id = p_simulation_id
3834: AND NOT EXISTS (SELECT sl.ship_line_id
3835: FROM inl_ship_lines sl,
3836: inl_ship_headers sh

Line 4050: po_headers ph

4046: l_po_currency,
4047: l_po_number
4048: FROM po_line_locations pll,
4049: po_lines pl,
4050: po_headers ph
4051: WHERE ph.po_header_id = pl.po_header_id
4052: AND pl.po_line_id = pll.po_line_id
4053: AND pll.line_location_id = c_ship_ln_tab(i).ship_line_source_id;
4054: EXCEPTION

Line 4318: po_headers_all ph,

4314: po_vendors pv1,
4315: po_vendor_sites pvs,
4316: po_vendors pv,
4317: po_releases pr, -- Bug 14280113
4318: po_headers_all ph,
4319: inl_simulations s
4320: WHERE pr.po_header_id (+) = ph.po_header_id -- Bug 14280113
4321: AND pvs1.vendor_site_id = s.vendor_site_id
4322: AND pv1.vendor_id = s.vendor_id

Line 4327: AND ((s.parent_table_name = 'PO_HEADERS'

4323: AND pvs.vendor_site_id = ph.vendor_site_id
4324: AND pv.vendor_id = ph.vendor_id
4325: -- Bug 14280113
4326: --AND ph.po_header_id = s.parent_table_id
4327: AND ((s.parent_table_name = 'PO_HEADERS'
4328: AND s.parent_table_id = ph.po_header_id)
4329: OR (s.parent_table_name = 'PO_RELEASES'
4330: AND s.parent_table_id = pr.po_release_id))
4331: AND s.simulation_id = p_simulation_id;

Line 4720: FROM po_headers_all ph,

4716: SELECT ph.vendor_id,
4717: ph.vendor_site_id,
4718: pl.item_id,
4719: pll.ship_to_organization_id
4720: FROM po_headers_all ph,
4721: po_lines_all pl,
4722: po_line_locations_all pll
4723: WHERE ph.po_header_id = pl.po_header_id
4724: AND pl.po_line_id = pll.po_line_id