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.INV_LABEL_PVT10 dependencies on HZ_LOCATIONS

Line 838: l_location_id hz_locations.location_id%TYPE;

834: l_ship_to_org_id oe_order_headers_all.ship_to_org_id%TYPE;
835: l_invoice_to_org_id oe_order_headers_all.invoice_to_org_id%TYPE;
836: l_deliver_to_org_id oe_order_headers_all.deliver_to_org_id%TYPE;
837: l_organization_code mtl_parameters.organization_code%TYPE;
838: l_location_id hz_locations.location_id%TYPE;
839: l_location_name hz_cust_site_uses_all.location%TYPE;
840: l_organization_name org_organization_definitions.organization_name%TYPE;
841: l_customer_number hz_cust_accounts.account_number%TYPE;
842: l_sold_from_location_id hz_locations.location_id%TYPE;

Line 842: l_sold_from_location_id hz_locations.location_id%TYPE;

838: l_location_id hz_locations.location_id%TYPE;
839: l_location_name hz_cust_site_uses_all.location%TYPE;
840: l_organization_name org_organization_definitions.organization_name%TYPE;
841: l_customer_number hz_cust_accounts.account_number%TYPE;
842: l_sold_from_location_id hz_locations.location_id%TYPE;
843: l_sold_to_location_id hz_locations.location_id%TYPE;
844: l_ship_from_location_id hz_locations.location_id%TYPE;
845: l_ship_to_location_id hz_locations.location_id%TYPE;
846: l_invoice_to_location_id hz_locations.location_id%TYPE;

Line 843: l_sold_to_location_id hz_locations.location_id%TYPE;

839: l_location_name hz_cust_site_uses_all.location%TYPE;
840: l_organization_name org_organization_definitions.organization_name%TYPE;
841: l_customer_number hz_cust_accounts.account_number%TYPE;
842: l_sold_from_location_id hz_locations.location_id%TYPE;
843: l_sold_to_location_id hz_locations.location_id%TYPE;
844: l_ship_from_location_id hz_locations.location_id%TYPE;
845: l_ship_to_location_id hz_locations.location_id%TYPE;
846: l_invoice_to_location_id hz_locations.location_id%TYPE;
847: l_deliver_to_location_id hz_locations.location_id%TYPE;

Line 844: l_ship_from_location_id hz_locations.location_id%TYPE;

840: l_organization_name org_organization_definitions.organization_name%TYPE;
841: l_customer_number hz_cust_accounts.account_number%TYPE;
842: l_sold_from_location_id hz_locations.location_id%TYPE;
843: l_sold_to_location_id hz_locations.location_id%TYPE;
844: l_ship_from_location_id hz_locations.location_id%TYPE;
845: l_ship_to_location_id hz_locations.location_id%TYPE;
846: l_invoice_to_location_id hz_locations.location_id%TYPE;
847: l_deliver_to_location_id hz_locations.location_id%TYPE;
848: l_ship_from_organization_code mtl_parameters.organization_code%TYPE;

Line 845: l_ship_to_location_id hz_locations.location_id%TYPE;

841: l_customer_number hz_cust_accounts.account_number%TYPE;
842: l_sold_from_location_id hz_locations.location_id%TYPE;
843: l_sold_to_location_id hz_locations.location_id%TYPE;
844: l_ship_from_location_id hz_locations.location_id%TYPE;
845: l_ship_to_location_id hz_locations.location_id%TYPE;
846: l_invoice_to_location_id hz_locations.location_id%TYPE;
847: l_deliver_to_location_id hz_locations.location_id%TYPE;
848: l_ship_from_organization_code mtl_parameters.organization_code%TYPE;
849: l_ship_to_organization_code mtl_parameters.organization_code%TYPE;

Line 846: l_invoice_to_location_id hz_locations.location_id%TYPE;

842: l_sold_from_location_id hz_locations.location_id%TYPE;
843: l_sold_to_location_id hz_locations.location_id%TYPE;
844: l_ship_from_location_id hz_locations.location_id%TYPE;
845: l_ship_to_location_id hz_locations.location_id%TYPE;
846: l_invoice_to_location_id hz_locations.location_id%TYPE;
847: l_deliver_to_location_id hz_locations.location_id%TYPE;
848: l_ship_from_organization_code mtl_parameters.organization_code%TYPE;
849: l_ship_to_organization_code mtl_parameters.organization_code%TYPE;
850: l_sold_from_organization_code mtl_parameters.organization_code%TYPE;

Line 847: l_deliver_to_location_id hz_locations.location_id%TYPE;

843: l_sold_to_location_id hz_locations.location_id%TYPE;
844: l_ship_from_location_id hz_locations.location_id%TYPE;
845: l_ship_to_location_id hz_locations.location_id%TYPE;
846: l_invoice_to_location_id hz_locations.location_id%TYPE;
847: l_deliver_to_location_id hz_locations.location_id%TYPE;
848: l_ship_from_organization_code mtl_parameters.organization_code%TYPE;
849: l_ship_to_organization_code mtl_parameters.organization_code%TYPE;
850: l_sold_from_organization_code mtl_parameters.organization_code%TYPE;
851: l_sold_to_organization_code mtl_parameters.organization_code%TYPE;

Line 854: l_address5 hz_locations.address4%TYPE;

850: l_sold_from_organization_code mtl_parameters.organization_code%TYPE;
851: l_sold_to_organization_code mtl_parameters.organization_code%TYPE;
852: l_invoice_to_organization_code mtl_parameters.organization_code%TYPE;
853: l_deliver_to_organization_code mtl_parameters.organization_code%TYPE;
854: l_address5 hz_locations.address4%TYPE;
855: l_header_id oe_order_headers_all.header_id%TYPE := p_header_id;
856:
857:
858: CURSOR oe_header_curs IS

Line 1236: FROM hz_locations hz

1232: hz.state state,hz.county county,
1233: hz.country country,hz.province province,
1234: hz.description location_code, hz.description description,
1235: NULL telephone_number_1
1236: FROM hz_locations hz
1237: ) LOC
1238: WHERE location_id = c_location_id;
1239:
1240: CURSOR customer_site(c_site_use_code VARCHAR2,

Line 1512: FROM hz_locations hz

1508: hz.city city,hz.postal_code postal_code,
1509: hz.state state,hz.county county,
1510: hz.country country,hz.province province,
1511: hz.description location_code, hz.description location_description
1512: FROM hz_locations hz
1513: WHERE hz.location_id = c_location_id;
1514:
1515: CURSOR oe_lines_curs IS
1516: SELECT