2559: , SC.SALES_GROUP_ID
2560: --SG}
2561: , SC.LOCK_CONTROL
2562: FROM OE_SALES_CREDITS SC
2563: , OE_SALES_CREDIT_TYPES SCT
2564: WHERE SC.sales_credit_type_id = sct.sales_credit_type_id
2565: AND SCT.quota_flag = p_quota_flag
2566: AND SC.line_id = p_line_id;
2567:
2677: , SC.Sales_Group_Id
2678: --SG
2679: , SC.LOCK_CONTROL
2680: FROM OE_SALES_CREDITS SC
2681: , OE_SALES_CREDIT_TYPES SCT
2682: WHERE SC.sales_credit_type_id = sct.sales_credit_type_id
2683: AND SCT.quota_flag = p_quota_flag
2684: AND SC.header_id = p_header_id
2685: AND SC.line_id IS NULL;