APPS.OE_FLEX_COGS_PUB dependencies on OE_SALES_CREDIT_TYPES

Line 1143: OE_SALES_CREDIT_TYPES SCT

1139: WHERE LINE_ID = L_ORDER_LINE_ID
1140: AND SALESREP_ID = (
1141: SELECT MIN(SALESREP_ID)
1142: FROM OE_SALES_CREDITS SC ,
1143: OE_SALES_CREDIT_TYPES SCT
1144: WHERE SC.LINE_ID = L_ORDER_LINE_ID
1145: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
1146: AND SCT.QUOTA_FLAG = 'Y'
1147: AND SC.PERCENT = (

Line 1150: OE_SALES_CREDIT_TYPES SCT

1146: AND SCT.QUOTA_FLAG = 'Y'
1147: AND SC.PERCENT = (
1148: SELECT MAX(PERCENT)
1149: FROM OE_SALES_CREDITS SC, --Bug4096083 start
1150: OE_SALES_CREDIT_TYPES SCT
1151: WHERE SC.LINE_ID = L_ORDER_LINE_ID
1152: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
1153: AND SCT.QUOTA_FLAG = 'Y' --Bug4096083 end
1154: )

Line 1172: OE_SALES_CREDIT_TYPES SCT

1168: AND LINE_ID IS NULL
1169: AND SALESREP_ID = (
1170: SELECT MIN(SALESREP_ID)
1171: FROM OE_SALES_CREDITS SC ,
1172: OE_SALES_CREDIT_TYPES SCT
1173: WHERE SC.HEADER_ID = L_HEADER_ID
1174: AND SC.LINE_ID IS NULL
1175: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
1176: AND SCT.QUOTA_FLAG = 'Y'

Line 1180: OE_SALES_CREDIT_TYPES SCT

1176: AND SCT.QUOTA_FLAG = 'Y'
1177: AND SC.PERCENT = (
1178: SELECT MAX(PERCENT)
1179: FROM OE_SALES_CREDITS SC, --Bug4096083 start
1180: OE_SALES_CREDIT_TYPES SCT
1181: WHERE SC.HEADER_ID = L_HEADER_ID
1182: AND SC.LINE_ID IS NULL
1183: AND SC.SALES_CREDIT_TYPE_ID = SCT.SALES_CREDIT_TYPE_ID
1184: AND SCT.QUOTA_FLAG = 'Y' --Bug4096083 end