DBA Data[Home] [Help]

APPS.PO_ITEMS_SV3 dependencies on MTL_SYSTEM_ITEMS

Line 46: -- Get item and ship_to organization taxable_flag from MTL_SYSTEM_ITEMS

42:
43: x_return_taxable_flag := x_user_pref_taxable_flag;
44:
45: ELSE
46: -- Get item and ship_to organization taxable_flag from MTL_SYSTEM_ITEMS
47:
48: IF x_item_id is not NULL THEN
49:
50: IF x_item_org_id is not NULL AND

Line 60: FROM MTL_SYSTEM_ITEMS msi

56:
57: x_progress := '010';
58: SELECT msi.taxable_flag
59: INTO x_item_org_taxable_flag
60: FROM MTL_SYSTEM_ITEMS msi
61: WHERE msi.inventory_item_id = x_item_id
62: AND msi.organization_id = x_item_org_id;
63:
64: -- dbms_output.put_line ('Get item organization_taxable_flag ' ||

Line 90: FROM MTL_SYSTEM_ITEMS msi

86:
87: x_progress := '015';
88: SELECT msi.taxable_flag
89: INTO x_ship_to_org_taxable_flag
90: FROM MTL_SYSTEM_ITEMS msi
91: WHERE msi.inventory_item_id = x_item_id
92: AND msi.organization_id = x_ship_to_org_id;
93:
94: -- dbms_output.put_line ('Get ship_to organization_taxable_flag ' ||