APPS.OE_RMA_LINE_VALIDATE dependencies on SO_LINES

Line 36: FROM SO_LINES L1

32:
33: /* Get Original Ordered Quantity from Sales Order Line */
34: SELECT (L1.ORDERED_QUANTITY - NVL(L1.CANCELLED_QUANTITY,0))
35: INTO L_ORIGINAL
36: FROM SO_LINES L1
37: WHERE L1.LINE_ID = P_RETURN_REFERENCE_ID;
38:
39: /* Returns using SO or PO reference */
40:

Line 43: FROM SO_LINES L2

39: /* Returns using SO or PO reference */
40:
41: SELECT NVL(SUM(L2.ORDERED_QUANTITY - NVL(L2.CANCELLED_QUANTITY,0)), 0)
42: INTO L_SO_PO_SUM
43: FROM SO_LINES L2
44: WHERE L2.RETURN_REFERENCE_ID = P_RETURN_REFERENCE_ID
45: AND L2.RETURN_REFERENCE_TYPE_CODE IN ('ORDER', 'PO')
46: AND L2.LINE_ID <> P_LINE_ID;
47:

Line 52: FROM SO_LINES L2

48: /* Returns using Inv Reference */
49:
50: SELECT NVL(SUM(L2.ORDERED_QUANTITY - NVL(L2.CANCELLED_QUANTITY,0)), 0)
51: INTO L_INV_SUM
52: FROM SO_LINES L2
53: WHERE L2.RETURN_REFERENCE_ID IN (SELECT CUSTOMER_TRX_LINE_ID
54: FROM RA_CUSTOMER_TRX_LINES
55: WHERE INTERFACE_LINE_CONTEXT
56: = FND_PROFILE.Value_Specific('SO_SOURCE_CODE')

Line 74: FROM SO_LINES L1

70:
71: /* Get Original Ordered Quantity from Sales Order Line */
72: SELECT (L1.ORDERED_QUANTITY - NVL(L1.CANCELLED_QUANTITY,0))
73: INTO L_ORIGINAL
74: FROM SO_LINES L1
75: WHERE L1.LINE_ID = L_TEMP_LINE_ID;
76:
77: /* Returns using SO or PO reference */
78:

Line 81: FROM SO_LINES L2

77: /* Returns using SO or PO reference */
78:
79: SELECT NVL(SUM(L2.ORDERED_QUANTITY - NVL(L2.CANCELLED_QUANTITY,0)), 0)
80: INTO L_SO_PO_SUM
81: FROM SO_LINES L2
82: WHERE L2.RETURN_REFERENCE_ID = L_TEMP_LINE_ID
83: AND L2.RETURN_REFERENCE_TYPE_CODE IN ('ORDER', 'PO')
84: AND L2.LINE_ID <> P_LINE_ID;
85:

Line 90: FROM SO_LINES L2

86: /* Returns using Inv Reference */
87:
88: SELECT NVL(SUM(L2.ORDERED_QUANTITY - NVL(L2.CANCELLED_QUANTITY,0)), 0)
89: INTO L_INV_SUM
90: FROM SO_LINES L2
91: WHERE L2.RETURN_REFERENCE_ID = P_RETURN_REFERENCE_ID
92: AND L2.RETURN_REFERENCE_TYPE_CODE = 'INVOICE'
93: AND L2.LINE_ID <> P_LINE_ID;
94:

Line 130: FROM SO_LINES

126: P_RESULT := 0;
127:
128: SELECT 'duplicate'
129: INTO L_SUCCESS
130: FROM SO_LINES
131: WHERE ((P_ROW_ID IS NULL) OR
132: (ROWID <> P_ROW_ID))
133: and parent_line_id is NULL
134: AND LINE_NUMBER = P_LINE_NUMBER