DBA Data[Home] [Help]

APPS.PO_INTERFACE_S dependencies on PO_DISTRIBUTIONS_S

Line 6820: SET po_distribution_id = po_distributions_s.NEXTVAL,

6816: --SQL WHAT: Update po_distributions_interface table with
6817: -- po_distribution_id's and distribution_num
6818:
6819: UPDATE po_distributions_interface
6820: SET po_distribution_id = po_distributions_s.NEXTVAL,
6821: distribution_num = x_distribution_num + rownum
6822: WHERE interface_header_id = interface.interface_header_id
6823: AND interface_line_id = interface.interface_line_id;
6824:

Line 14921: PO_DISTRIBUTIONS_S.NEXTVAL

14917: , amount_ordered
14918: ,tax_attribute_update_code --
14919: )
14920: SELECT
14921: PO_DISTRIBUTIONS_S.NEXTVAL
14922: , interface.last_update_date
14923: , interface.last_updated_by
14924: , interface.last_update_login
14925: , interface.creation_date

Line 15085: PO_DISTRIBUTIONS_S.NEXTVAL

15081: , set_of_books_id
15082: ,tax_attribute_update_code --
15083: )
15084: SELECT
15085: PO_DISTRIBUTIONS_S.NEXTVAL
15086: , interface.last_update_date
15087: , interface.last_updated_by
15088: , interface.last_update_login
15089: , interface.creation_date

Line 15194: PO_DISTRIBUTIONS_S.NEXTVAL

15190: , set_of_books_id
15191: ,tax_attribute_update_code --
15192: )
15193: SELECT
15194: PO_DISTRIBUTIONS_S.NEXTVAL
15195: , interface.last_update_date
15196: , interface.last_updated_by
15197: , interface.last_update_login
15198: , interface.creation_date