APPS.OE_QUERY dependencies on MTL_SO_RMA_INTERFACE

Line 865: -- from the MTL_SO_RMA_INTERFACE table

861: --
862: -- RETURN LINES VIEW
863: --
864: -- Returns total received quantity of the given line_id
865: -- from the MTL_SO_RMA_INTERFACE table
866: --
867: -----------------------------------------------------------
868: function Received_qty( p_line_id NUMBER)
869: RETURN NUMBER IS

Line 955: , MTL_SO_RMA_INTERFACE MTLSRI

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;
959:

Line 967: , MTL_SO_RMA_INTERFACE MTLSRI

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;
971: END IF;

Line 976: from mtl_so_rma_interface

972:
973: IF (l_s29 = 17 and l_qty_received = 0 ) then
974: select min(rma_interface_id)
975: into l_interface_id
976: from mtl_so_rma_interface
977: where rma_line_id = p_line_id;
978: ELSE
979: RETURN(l_qty_received);
980: END IF;

Line 998: -- from the MTL_SO_RMA_INTERFACE table

994: --
995: -- RETURN LINES VIEW
996: --
997: -- Returns the total accepted quantity of the given line_id
998: -- from the MTL_SO_RMA_INTERFACE table
999: --
1000: -----------------------------------------------------------
1001: function Accepted_qty( p_line_id NUMBER)
1002: RETURN NUMBER IS

Line 1088: , MTL_SO_RMA_INTERFACE MTLSRI

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;
1092:

Line 1100: , MTL_SO_RMA_INTERFACE MTLSRI

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;
1104: END IF;

Line 1109: from mtl_so_rma_interface

1105:
1106: IF (l_s29 = 17 and l_qty_received = 0 ) then
1107: select min(rma_interface_id)
1108: into l_interface_id
1109: from mtl_so_rma_interface
1110: where rma_line_id = p_line_id;
1111: ELSE
1112: RETURN(l_qty_received);
1113: END IF;

Line 1131: -- from the MTL_SO_RMA_INTERFACE table

1127: --
1128: -- RETURN LINES VIEW
1129: --
1130: -- Returns the latest received date for the given line_id
1131: -- from the MTL_SO_RMA_INTERFACE table
1132: --
1133: -----------------------------------------------------------
1134: function Received_Date( p_line_id NUMBER,
1135: P_S29_DATE DATE)

Line 1145: , MTL_SO_RMA_INTERFACE MTLSRI

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;
1149:

Line 1166: -- from the MTL_SO_RMA_INTERFACE table

1162: --
1163: -- RETURN LINES VIEW
1164: --
1165: -- Returns the latest accetped date for the given line_id
1166: -- from the MTL_SO_RMA_INTERFACE table
1167: --
1168: -----------------------------------------------------------
1169: function Accepted_Date( p_line_id NUMBER,
1170: P_S29_DATE DATE)

Line 1180: , MTL_SO_RMA_INTERFACE MTLSRI

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;
1184: