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_MO_PURGE dependencies on MTL_TXN_REQUEST_LINES

Line 27: line_id MTL_TXN_REQUEST_LINES.line_id%TYPE,

23: --Bug #4864356
24: --Added new columns to the record type to avoid re-querying MOL
25: TYPE MOL_REC IS RECORD(
26: header_id MTL_TXN_REQUEST_HEADERS.header_id%TYPE,
27: line_id MTL_TXN_REQUEST_LINES.line_id%TYPE,
28: mo_type MTL_TXN_REQUEST_HEADERS.move_order_type%TYPE,
29: line_status MTL_TXN_REQUEST_LINES.line_status%TYPE,
30: quantity MTL_TXN_REQUEST_LINES.quantity%TYPE,
31: quantity_detailed MTL_TXN_REQUEST_LINES.quantity_detailed%TYPE,

Line 29: line_status MTL_TXN_REQUEST_LINES.line_status%TYPE,

25: TYPE MOL_REC IS RECORD(
26: header_id MTL_TXN_REQUEST_HEADERS.header_id%TYPE,
27: line_id MTL_TXN_REQUEST_LINES.line_id%TYPE,
28: mo_type MTL_TXN_REQUEST_HEADERS.move_order_type%TYPE,
29: line_status MTL_TXN_REQUEST_LINES.line_status%TYPE,
30: quantity MTL_TXN_REQUEST_LINES.quantity%TYPE,
31: quantity_detailed MTL_TXN_REQUEST_LINES.quantity_detailed%TYPE,
32: quantity_delivered MTL_TXN_REQUEST_LINES.quantity_delivered%TYPE,
33: required_quantity MTL_TXN_REQUEST_LINES.required_quantity%TYPE,

Line 30: quantity MTL_TXN_REQUEST_LINES.quantity%TYPE,

26: header_id MTL_TXN_REQUEST_HEADERS.header_id%TYPE,
27: line_id MTL_TXN_REQUEST_LINES.line_id%TYPE,
28: mo_type MTL_TXN_REQUEST_HEADERS.move_order_type%TYPE,
29: line_status MTL_TXN_REQUEST_LINES.line_status%TYPE,
30: quantity MTL_TXN_REQUEST_LINES.quantity%TYPE,
31: quantity_detailed MTL_TXN_REQUEST_LINES.quantity_detailed%TYPE,
32: quantity_delivered MTL_TXN_REQUEST_LINES.quantity_delivered%TYPE,
33: required_quantity MTL_TXN_REQUEST_LINES.required_quantity%TYPE,
34: txn_source_line_id MTL_TXN_REQUEST_LINES.txn_source_line_id%TYPE);

Line 31: quantity_detailed MTL_TXN_REQUEST_LINES.quantity_detailed%TYPE,

27: line_id MTL_TXN_REQUEST_LINES.line_id%TYPE,
28: mo_type MTL_TXN_REQUEST_HEADERS.move_order_type%TYPE,
29: line_status MTL_TXN_REQUEST_LINES.line_status%TYPE,
30: quantity MTL_TXN_REQUEST_LINES.quantity%TYPE,
31: quantity_detailed MTL_TXN_REQUEST_LINES.quantity_detailed%TYPE,
32: quantity_delivered MTL_TXN_REQUEST_LINES.quantity_delivered%TYPE,
33: required_quantity MTL_TXN_REQUEST_LINES.required_quantity%TYPE,
34: txn_source_line_id MTL_TXN_REQUEST_LINES.txn_source_line_id%TYPE);
35:

Line 32: quantity_delivered MTL_TXN_REQUEST_LINES.quantity_delivered%TYPE,

28: mo_type MTL_TXN_REQUEST_HEADERS.move_order_type%TYPE,
29: line_status MTL_TXN_REQUEST_LINES.line_status%TYPE,
30: quantity MTL_TXN_REQUEST_LINES.quantity%TYPE,
31: quantity_detailed MTL_TXN_REQUEST_LINES.quantity_detailed%TYPE,
32: quantity_delivered MTL_TXN_REQUEST_LINES.quantity_delivered%TYPE,
33: required_quantity MTL_TXN_REQUEST_LINES.required_quantity%TYPE,
34: txn_source_line_id MTL_TXN_REQUEST_LINES.txn_source_line_id%TYPE);
35:
36: END INV_MO_PURGE;

Line 33: required_quantity MTL_TXN_REQUEST_LINES.required_quantity%TYPE,

29: line_status MTL_TXN_REQUEST_LINES.line_status%TYPE,
30: quantity MTL_TXN_REQUEST_LINES.quantity%TYPE,
31: quantity_detailed MTL_TXN_REQUEST_LINES.quantity_detailed%TYPE,
32: quantity_delivered MTL_TXN_REQUEST_LINES.quantity_delivered%TYPE,
33: required_quantity MTL_TXN_REQUEST_LINES.required_quantity%TYPE,
34: txn_source_line_id MTL_TXN_REQUEST_LINES.txn_source_line_id%TYPE);
35:
36: END INV_MO_PURGE;
37:

Line 34: txn_source_line_id MTL_TXN_REQUEST_LINES.txn_source_line_id%TYPE);

30: quantity MTL_TXN_REQUEST_LINES.quantity%TYPE,
31: quantity_detailed MTL_TXN_REQUEST_LINES.quantity_detailed%TYPE,
32: quantity_delivered MTL_TXN_REQUEST_LINES.quantity_delivered%TYPE,
33: required_quantity MTL_TXN_REQUEST_LINES.required_quantity%TYPE,
34: txn_source_line_id MTL_TXN_REQUEST_LINES.txn_source_line_id%TYPE);
35:
36: END INV_MO_PURGE;
37:
38: