DBA Data[Home] [Help]

APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on OE_ORDER_LINES_ALL

Line 8: shipping_quantity oe_order_lines_all.shipping_quantity%TYPE,

4: --
5: --
6:
7: TYPE t_InterfaceRecord is RECORD (
8: shipping_quantity oe_order_lines_all.shipping_quantity%TYPE,
9: shipping_quantity_UOM oe_order_lines_all.shipping_quantity_uom%TYPE,
10: actual_shipment_date oe_order_lines_all.actual_shipment_date%TYPE,
11: over_ship_reason_code oe_order_lines_all.over_ship_reason_code%TYPE);
12: TYPE process_order_table is table of t_InterfaceRecord INDEX BY BINARY_INTEGER;

Line 9: shipping_quantity_UOM oe_order_lines_all.shipping_quantity_uom%TYPE,

5: --
6:
7: TYPE t_InterfaceRecord is RECORD (
8: shipping_quantity oe_order_lines_all.shipping_quantity%TYPE,
9: shipping_quantity_UOM oe_order_lines_all.shipping_quantity_uom%TYPE,
10: actual_shipment_date oe_order_lines_all.actual_shipment_date%TYPE,
11: over_ship_reason_code oe_order_lines_all.over_ship_reason_code%TYPE);
12: TYPE process_order_table is table of t_InterfaceRecord INDEX BY BINARY_INTEGER;
13:

Line 10: actual_shipment_date oe_order_lines_all.actual_shipment_date%TYPE,

6:
7: TYPE t_InterfaceRecord is RECORD (
8: shipping_quantity oe_order_lines_all.shipping_quantity%TYPE,
9: shipping_quantity_UOM oe_order_lines_all.shipping_quantity_uom%TYPE,
10: actual_shipment_date oe_order_lines_all.actual_shipment_date%TYPE,
11: over_ship_reason_code oe_order_lines_all.over_ship_reason_code%TYPE);
12: TYPE process_order_table is table of t_InterfaceRecord INDEX BY BINARY_INTEGER;
13:
14:

Line 11: over_ship_reason_code oe_order_lines_all.over_ship_reason_code%TYPE);

7: TYPE t_InterfaceRecord is RECORD (
8: shipping_quantity oe_order_lines_all.shipping_quantity%TYPE,
9: shipping_quantity_UOM oe_order_lines_all.shipping_quantity_uom%TYPE,
10: actual_shipment_date oe_order_lines_all.actual_shipment_date%TYPE,
11: over_ship_reason_code oe_order_lines_all.over_ship_reason_code%TYPE);
12: TYPE process_order_table is table of t_InterfaceRecord INDEX BY BINARY_INTEGER;
13:
14:
15: --

Line 495: order_line_quantity oe_order_lines_all.ordered_quantity%TYPE,

491: source_header_id wsh_delivery_details.source_header_id%TYPE,
492: source_header_number wsh_delivery_details.source_header_number%TYPE,
493: source_line_set_id wsh_delivery_details.source_line_set_id%TYPE,
494: source_line_id wsh_delivery_details.source_line_id%TYPE,
495: order_line_quantity oe_order_lines_all.ordered_quantity%TYPE,
496: -- muom
497: order_line_quantity2 oe_order_lines_all.ordered_quantity%TYPE,
498: requested_quantity_uom wsh_delivery_details.requested_quantity_uom%TYPE,
499: requested_quantity_uom2 wsh_delivery_details.requested_quantity_uom2%TYPE,

Line 497: order_line_quantity2 oe_order_lines_all.ordered_quantity%TYPE,

493: source_line_set_id wsh_delivery_details.source_line_set_id%TYPE,
494: source_line_id wsh_delivery_details.source_line_id%TYPE,
495: order_line_quantity oe_order_lines_all.ordered_quantity%TYPE,
496: -- muom
497: order_line_quantity2 oe_order_lines_all.ordered_quantity%TYPE,
498: requested_quantity_uom wsh_delivery_details.requested_quantity_uom%TYPE,
499: requested_quantity_uom2 wsh_delivery_details.requested_quantity_uom2%TYPE,
500: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
501: order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE,

Line 500: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,

496: -- muom
497: order_line_quantity2 oe_order_lines_all.ordered_quantity%TYPE,
498: requested_quantity_uom wsh_delivery_details.requested_quantity_uom%TYPE,
499: requested_quantity_uom2 wsh_delivery_details.requested_quantity_uom2%TYPE,
500: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
501: order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE,
502: ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE,
503: ordered_quantity_uom2 oe_order_lines_all.ordered_quantity_uom2%TYPE,
504: model_remnant_flag oe_order_lines_all.model_remnant_flag%TYPE,

Line 501: order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE,

497: order_line_quantity2 oe_order_lines_all.ordered_quantity%TYPE,
498: requested_quantity_uom wsh_delivery_details.requested_quantity_uom%TYPE,
499: requested_quantity_uom2 wsh_delivery_details.requested_quantity_uom2%TYPE,
500: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
501: order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE,
502: ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE,
503: ordered_quantity_uom2 oe_order_lines_all.ordered_quantity_uom2%TYPE,
504: model_remnant_flag oe_order_lines_all.model_remnant_flag%TYPE,
505: item_type_code oe_order_lines_all.item_type_code%TYPE,

Line 502: ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE,

498: requested_quantity_uom wsh_delivery_details.requested_quantity_uom%TYPE,
499: requested_quantity_uom2 wsh_delivery_details.requested_quantity_uom2%TYPE,
500: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
501: order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE,
502: ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE,
503: ordered_quantity_uom2 oe_order_lines_all.ordered_quantity_uom2%TYPE,
504: model_remnant_flag oe_order_lines_all.model_remnant_flag%TYPE,
505: item_type_code oe_order_lines_all.item_type_code%TYPE,
506: calculate_price_flag oe_order_lines_all.calculate_price_flag%TYPE,

Line 503: ordered_quantity_uom2 oe_order_lines_all.ordered_quantity_uom2%TYPE,

499: requested_quantity_uom2 wsh_delivery_details.requested_quantity_uom2%TYPE,
500: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
501: order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE,
502: ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE,
503: ordered_quantity_uom2 oe_order_lines_all.ordered_quantity_uom2%TYPE,
504: model_remnant_flag oe_order_lines_all.model_remnant_flag%TYPE,
505: item_type_code oe_order_lines_all.item_type_code%TYPE,
506: calculate_price_flag oe_order_lines_all.calculate_price_flag%TYPE,
507: ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,

Line 504: model_remnant_flag oe_order_lines_all.model_remnant_flag%TYPE,

500: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
501: order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE,
502: ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE,
503: ordered_quantity_uom2 oe_order_lines_all.ordered_quantity_uom2%TYPE,
504: model_remnant_flag oe_order_lines_all.model_remnant_flag%TYPE,
505: item_type_code oe_order_lines_all.item_type_code%TYPE,
506: calculate_price_flag oe_order_lines_all.calculate_price_flag%TYPE,
507: ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
508: ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,

Line 505: item_type_code oe_order_lines_all.item_type_code%TYPE,

501: order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE,
502: ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE,
503: ordered_quantity_uom2 oe_order_lines_all.ordered_quantity_uom2%TYPE,
504: model_remnant_flag oe_order_lines_all.model_remnant_flag%TYPE,
505: item_type_code oe_order_lines_all.item_type_code%TYPE,
506: calculate_price_flag oe_order_lines_all.calculate_price_flag%TYPE,
507: ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
508: ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
509: org_id oe_order_lines_all.org_id%TYPE,

Line 506: calculate_price_flag oe_order_lines_all.calculate_price_flag%TYPE,

502: ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE,
503: ordered_quantity_uom2 oe_order_lines_all.ordered_quantity_uom2%TYPE,
504: model_remnant_flag oe_order_lines_all.model_remnant_flag%TYPE,
505: item_type_code oe_order_lines_all.item_type_code%TYPE,
506: calculate_price_flag oe_order_lines_all.calculate_price_flag%TYPE,
507: ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
508: ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
509: org_id oe_order_lines_all.org_id%TYPE,
510: organization_id wsh_delivery_details.organization_id%TYPE,

Line 509: org_id oe_order_lines_all.org_id%TYPE,

505: item_type_code oe_order_lines_all.item_type_code%TYPE,
506: calculate_price_flag oe_order_lines_all.calculate_price_flag%TYPE,
507: ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
508: ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
509: org_id oe_order_lines_all.org_id%TYPE,
510: organization_id wsh_delivery_details.organization_id%TYPE,
511: oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
512: initial_pickup_date wsh_new_deliveries.initial_pickup_date%TYPE,
513: top_model_line_id wsh_delivery_details.top_model_line_id%TYPE ,

Line 519: flow_status_code oe_order_lines_all.flow_status_code%TYPE,

515: ship_set_id wsh_delivery_details.ship_set_id%TYPE,
516: ship_model_complete_flag wsh_delivery_details.ship_model_complete_flag%TYPE,
517: arrival_set_id wsh_delivery_details.arrival_set_id%TYPE,
518: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
519: flow_status_code oe_order_lines_all.flow_status_code%TYPE,
520: total_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
521: total_requested_quantity2 wsh_delivery_details.requested_quantity2%TYPE,
522: total_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,
523: total_shipped_quantity2 wsh_delivery_details.shipped_quantity2%TYPE,