DBA Data[Home] [Help]

APPS.ONT_OEXOECCH_XMLP_PKG dependencies on OE_LOOKUPS

Line 96: OE_LOOKUPS

92: SELECT
93: MEANING
94: INTO L_SHIP
95: FROM
96: OE_LOOKUPS
97: WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
98: AND LOOKUP_CODE = L_LOOKUP_CODE;
99: RP_SHIP := L_SHIP;
100: EXCEPTION

Line 115: OE_LOOKUPS

111: SELECT
112: MEANING
113: INTO L_ORD
114: FROM
115: OE_LOOKUPS
116: WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
117: AND LOOKUP_CODE = L_LOOKUP_CODE;
118: RP_ORDER := L_ORD;
119: EXCEPTION

Line 141: OE_LOOKUPS

137: SELECT
138: MEANING
139: INTO L_PICK
140: FROM
141: OE_LOOKUPS
142: WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
143: AND LOOKUP_CODE = L_LOOKUP_CODE;
144: RP_PICK := L_PICK;
145: EXCEPTION

Line 160: OE_LOOKUPS

156: SELECT
157: MEANING
158: INTO L_PACK
159: FROM
160: OE_LOOKUPS
161: WHERE LOOKUP_TYPE = L_LOOKUP_TYPE
162: AND LOOKUP_CODE = L_LOOKUP_CODE;
163: RP_PACK := L_PACK;
164: EXCEPTION