DBA Data[Home] [Help]

APPS.OE_VERSION_COMP dependencies on OE_SALES_CREDITS

Line 18995: FROM OE_SALES_CREDITS

18991: ,x_header_scredit_rec.WH_UPDATE_DATE
18992: ,x_header_scredit_rec.SALES_GROUP_ID
18993: ,x_header_scredit_rec.SALES_GROUP_UPDATED_FLAG
18994: ,x_header_scredit_rec.LOCK_CONTROL
18995: FROM OE_SALES_CREDITS
18996: WHERE
18997: HEADER_ID = p_header_id
18998: AND sales_credit_id = p_sales_credit_id
18999: AND LINE_ID IS NULL;

Line 20110: from oe_sales_credits

20106: --and phase_change_flag = p_transaction_phase_code
20107: and version_number in (p_prior_version,p_current_version,p_next_version)
20108: union
20109: SELECT sales_credit_id
20110: from oe_sales_credits
20111: where header_id=p_header_id
20112: and line_id is null;
20113: --and transaction_phase_code = p_transaction_phase_code;
20114:

Line 20417: FROM OE_SALES_CREDITS

20413: ,x_line_scredit_rec.WH_UPDATE_DATE
20414: ,x_line_scredit_rec.SALES_GROUP_ID
20415: ,x_line_scredit_rec.SALES_GROUP_UPDATED_FLAG
20416: ,x_line_scredit_rec.LOCK_CONTROL
20417: FROM OE_SALES_CREDITS
20418: WHERE
20419: HEADER_ID = p_header_id
20420: AND sales_credit_id = p_sales_credit_id
20421: AND LINE_ID IS NOT NULL;

Line 21585: from oe_sales_credits

21581: --and phase_change_flag = p_transaction_phase_code
21582: and version_number in (p_prior_version,p_current_version,p_next_version)
21583: union
21584: SELECT sales_credit_id,line_id
21585: from oe_sales_credits
21586: where header_id=p_header_id
21587: and line_id is not null;
21588: --and transaction_phase_code = p_transaction_phase_code;
21589: