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 OE_ORDER_HEADERS_ALL

Line 793: p_header_id oe_order_headers_all.header_id%TYPE ,

789:
790: /*=================================================================*/
791: PROCEDURE get_data_sale_header(
792: x_out_tbl IN OUT NOCOPY output_tbl_type,
793: p_header_id oe_order_headers_all.header_id%TYPE ,
794: p_line_id oe_order_lines_all.line_id%TYPE
795:
796: )IS
797:

Line 831: l_sold_from_org_id oe_order_headers_all.sold_from_org_id%TYPE;

827: -- Modification End for Bug # - 4418524
828: --
829:
830:
831: l_sold_from_org_id oe_order_headers_all.sold_from_org_id%TYPE;
832: l_sold_to_org_id oe_order_headers_all.sold_to_org_id%TYPE;
833: l_ship_from_org_id oe_order_headers_all.ship_from_org_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;

Line 832: l_sold_to_org_id oe_order_headers_all.sold_to_org_id%TYPE;

828: --
829:
830:
831: l_sold_from_org_id oe_order_headers_all.sold_from_org_id%TYPE;
832: l_sold_to_org_id oe_order_headers_all.sold_to_org_id%TYPE;
833: l_ship_from_org_id oe_order_headers_all.ship_from_org_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;

Line 833: l_ship_from_org_id oe_order_headers_all.ship_from_org_id%TYPE;

829:
830:
831: l_sold_from_org_id oe_order_headers_all.sold_from_org_id%TYPE;
832: l_sold_to_org_id oe_order_headers_all.sold_to_org_id%TYPE;
833: l_ship_from_org_id oe_order_headers_all.ship_from_org_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;

Line 834: l_ship_to_org_id oe_order_headers_all.ship_to_org_id%TYPE;

830:
831: l_sold_from_org_id oe_order_headers_all.sold_from_org_id%TYPE;
832: l_sold_to_org_id oe_order_headers_all.sold_to_org_id%TYPE;
833: l_ship_from_org_id oe_order_headers_all.ship_from_org_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;

Line 835: l_invoice_to_org_id oe_order_headers_all.invoice_to_org_id%TYPE;

831: l_sold_from_org_id oe_order_headers_all.sold_from_org_id%TYPE;
832: l_sold_to_org_id oe_order_headers_all.sold_to_org_id%TYPE;
833: l_ship_from_org_id oe_order_headers_all.ship_from_org_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;

Line 836: l_deliver_to_org_id oe_order_headers_all.deliver_to_org_id%TYPE;

832: l_sold_to_org_id oe_order_headers_all.sold_to_org_id%TYPE;
833: l_ship_from_org_id oe_order_headers_all.ship_from_org_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;

Line 855: l_header_id oe_order_headers_all.header_id%TYPE := p_header_id;

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
859: SELECT

Line 918: FROM OE_ORDER_HEADERS_ALL ohead

914: ohead.ship_to_org_id,
915: ohead.ship_from_org_id,
916: ohead.invoice_to_org_id,
917: ohead.deliver_to_org_id
918: FROM OE_ORDER_HEADERS_ALL ohead
919: , MTL_PARAMETERS ohead_mp
920: --
921: -- Modification Start for Bug # - 4418524
922: --

Line 1490: l_header_id oe_order_headers_all.header_id%TYPE;

1486: x_out_tbl IN OUT NOCOPY output_tbl_type,
1487: p_line_id oe_order_lines_all.line_id%TYPE
1488: )IS
1489:
1490: l_header_id oe_order_headers_all.header_id%TYPE;
1491:
1492: CURSOR hr_location_curs (c_location_id NUMBER) IS
1493: SELECT loc.location_id location_id,
1494: loc.address_line_1 address_line_1,