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 28: line_id MTL_TXN_REQUEST_LINES.line_id%TYPE,

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

Line 30: line_status MTL_TXN_REQUEST_LINES.line_status%TYPE,

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

Line 31: quantity MTL_TXN_REQUEST_LINES.quantity%TYPE,

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

Line 32: quantity_detailed MTL_TXN_REQUEST_LINES.quantity_detailed%TYPE,

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

Line 33: quantity_delivered MTL_TXN_REQUEST_LINES.quantity_delivered%TYPE,

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

Line 34: required_quantity MTL_TXN_REQUEST_LINES.required_quantity%TYPE,

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

Line 35: txn_source_line_id MTL_TXN_REQUEST_LINES.txn_source_line_id%TYPE,

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

Line 36: txn_source_id MTL_TXN_REQUEST_LINES.txn_source_id%TYPE,

32: quantity_detailed MTL_TXN_REQUEST_LINES.quantity_detailed%TYPE,
33: quantity_delivered MTL_TXN_REQUEST_LINES.quantity_delivered%TYPE,
34: required_quantity MTL_TXN_REQUEST_LINES.required_quantity%TYPE,
35: txn_source_line_id MTL_TXN_REQUEST_LINES.txn_source_line_id%TYPE,
36: txn_source_id MTL_TXN_REQUEST_LINES.txn_source_id%TYPE,
37: organization_id MTL_TXN_REQUEST_LINES.organization_id%TYPE);
38:
39: END INV_MO_PURGE;
40:

Line 37: organization_id MTL_TXN_REQUEST_LINES.organization_id%TYPE);

33: quantity_delivered MTL_TXN_REQUEST_LINES.quantity_delivered%TYPE,
34: required_quantity MTL_TXN_REQUEST_LINES.required_quantity%TYPE,
35: txn_source_line_id MTL_TXN_REQUEST_LINES.txn_source_line_id%TYPE,
36: txn_source_id MTL_TXN_REQUEST_LINES.txn_source_id%TYPE,
37: organization_id MTL_TXN_REQUEST_LINES.organization_id%TYPE);
38:
39: END INV_MO_PURGE;
40:
41: