APPS.OE_FLEX_COGS_PUB dependencies on OE_SALES_CREDIT_TYPES

Line 1157: OE_SALES_CREDIT_TYPES SCT

1153: WHERE LINE_ID = L_ORDER_LINE_ID
1154: AND SALESREP_ID = (
1155: SELECT MIN(SALESREP_ID)
1156: FROM OE_SALES_CREDITS SC ,
1157: OE_SALES_CREDIT_TYPES SCT
1158: WHERE SC.LINE_ID = L_ORDER_LINE_ID
1159: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
1160: AND SCT.QUOTA_FLAG = 'Y'
1161: AND SC.PERCENT = (

Line 1164: OE_SALES_CREDIT_TYPES SCT

1160: AND SCT.QUOTA_FLAG = 'Y'
1161: AND SC.PERCENT = (
1162: SELECT MAX(PERCENT)
1163: FROM OE_SALES_CREDITS SC, --Bug4096083 start
1164: OE_SALES_CREDIT_TYPES SCT
1165: WHERE SC.LINE_ID = L_ORDER_LINE_ID
1166: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
1167: AND SCT.QUOTA_FLAG = 'Y' --Bug4096083 end
1168: )

Line 1186: OE_SALES_CREDIT_TYPES SCT

1182: AND LINE_ID IS NULL
1183: AND SALESREP_ID = (
1184: SELECT MIN(SALESREP_ID)
1185: FROM OE_SALES_CREDITS SC ,
1186: OE_SALES_CREDIT_TYPES SCT
1187: WHERE SC.HEADER_ID = L_HEADER_ID
1188: AND SC.LINE_ID IS NULL
1189: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
1190: AND SCT.QUOTA_FLAG = 'Y'

Line 1194: OE_SALES_CREDIT_TYPES SCT

1190: AND SCT.QUOTA_FLAG = 'Y'
1191: AND SC.PERCENT = (
1192: SELECT MAX(PERCENT)
1193: FROM OE_SALES_CREDITS SC, --Bug4096083 start
1194: OE_SALES_CREDIT_TYPES SCT
1195: WHERE SC.HEADER_ID = L_HEADER_ID
1196: AND SC.LINE_ID IS NULL
1197: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
1198: AND SCT.QUOTA_FLAG = 'Y' --Bug4096083 end