DBA Data[Home] [Help]

APPS.PO_INTERFACE_S dependencies on PO_DISTRIBUTIONS_S

Line 7398: SET po_distribution_id = po_distributions_s.NEXTVAL,

7394: --SQL WHAT: Update po_distributions_interface table with
7395: -- po_distribution_id's and distribution_num
7396:
7397: UPDATE po_distributions_interface
7398: SET po_distribution_id = po_distributions_s.NEXTVAL,
7399: distribution_num = x_distribution_num + rownum
7400: WHERE interface_header_id = interface.interface_header_id
7401: AND interface_line_id = interface.interface_line_id;
7402:

Line 15830: PO_DISTRIBUTIONS_S.NEXTVAL

15826: , amount_ordered
15827: ,tax_attribute_update_code --
15828: )
15829: SELECT
15830: PO_DISTRIBUTIONS_S.NEXTVAL
15831: , interface.last_update_date
15832: , interface.last_updated_by
15833: , interface.last_update_login
15834: , interface.creation_date

Line 15994: PO_DISTRIBUTIONS_S.NEXTVAL

15990: , set_of_books_id
15991: ,tax_attribute_update_code --
15992: )
15993: SELECT
15994: PO_DISTRIBUTIONS_S.NEXTVAL
15995: , interface.last_update_date
15996: , interface.last_updated_by
15997: , interface.last_update_login
15998: , interface.creation_date

Line 16103: PO_DISTRIBUTIONS_S.NEXTVAL

16099: , set_of_books_id
16100: ,tax_attribute_update_code --
16101: )
16102: SELECT
16103: PO_DISTRIBUTIONS_S.NEXTVAL
16104: , interface.last_update_date
16105: , interface.last_updated_by
16106: , interface.last_update_login
16107: , interface.creation_date