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.OE_QUERY dependencies on MTL_SO_RMA_RECEIPTS

Line 954: FROM MTL_SO_RMA_RECEIPTS MTLSRR

950: /* calcuation is straight forward, not requiring any ratios. */
951: ELSE
952: SELECT sum(nvl(MTLSRR.received_quantity,0))
953: INTO l_qty_received
954: FROM MTL_SO_RMA_RECEIPTS MTLSRR
955: , MTL_SO_RMA_INTERFACE MTLSRI
956: WHERE MTLSRR.RMA_INTERFACE_ID = MTLSRI.RMA_INTERFACE_ID
957: AND MTLSRI.RMA_LINE_ID = p_line_id;
958: END IF;

Line 966: FROM MTL_SO_RMA_RECEIPTS MTLSRR

962: /* any ratios. */
963: ELSE
964: SELECT sum(nvl(MTLSRR.received_quantity,0))
965: INTO l_qty_received
966: FROM MTL_SO_RMA_RECEIPTS MTLSRR
967: , MTL_SO_RMA_INTERFACE MTLSRI
968: WHERE MTLSRR.RMA_INTERFACE_ID = MTLSRI.RMA_INTERFACE_ID
969: AND MTLSRI.RMA_LINE_ID = p_line_id;
970: END IF;

Line 1087: FROM MTL_SO_RMA_RECEIPTS MTLSRR

1083: /* calcuation is straight forward, not requiring any ratios. */
1084: ELSE
1085: SELECT sum(nvl(MTLSRR.accepted_quantity,0))
1086: INTO l_qty_received
1087: FROM MTL_SO_RMA_RECEIPTS MTLSRR
1088: , MTL_SO_RMA_INTERFACE MTLSRI
1089: WHERE MTLSRR.RMA_INTERFACE_ID = MTLSRI.RMA_INTERFACE_ID
1090: AND MTLSRI.RMA_LINE_ID = p_line_id;
1091: END IF;

Line 1099: FROM MTL_SO_RMA_RECEIPTS MTLSRR

1095: /* any ratios. */
1096: ELSE
1097: SELECT sum(nvl(MTLSRR.accepted_quantity,0))
1098: INTO l_qty_received
1099: FROM MTL_SO_RMA_RECEIPTS MTLSRR
1100: , MTL_SO_RMA_INTERFACE MTLSRI
1101: WHERE MTLSRR.RMA_INTERFACE_ID = MTLSRI.RMA_INTERFACE_ID
1102: AND MTLSRI.RMA_LINE_ID = p_line_id;
1103: END IF;

Line 1144: FROM MTL_SO_RMA_RECEIPTS MTLSRR

1140: BEGIN
1141:
1142: SELECT MAX( MTLSRR.RECEIPT_DATE )
1143: INTO L_Received_Date
1144: FROM MTL_SO_RMA_RECEIPTS MTLSRR
1145: , MTL_SO_RMA_INTERFACE MTLSRI
1146: WHERE MTLSRR.RMA_INTERFACE_ID = MTLSRI.RMA_INTERFACE_ID
1147: AND MTLSRI.RMA_LINE_ID = p_line_id
1148: AND MTLSRR.RECEIVED_QUANTITY > 0;

Line 1179: FROM MTL_SO_RMA_RECEIPTS MTLSRR

1175: BEGIN
1176:
1177: SELECT MAX( MTLSRR.RECEIPT_DATE )
1178: INTO L_Accepted_Date
1179: FROM MTL_SO_RMA_RECEIPTS MTLSRR
1180: , MTL_SO_RMA_INTERFACE MTLSRI
1181: WHERE MTLSRR.RMA_INTERFACE_ID = MTLSRI.RMA_INTERFACE_ID
1182: AND MTLSRI.RMA_LINE_ID = p_line_id
1183: AND MTLSRR.ACCEPTED_QUANTITY > 0;