APPS.INV_TXN_MANAGER_GRP dependencies on PO_ASL_ATTRIBUTES

Line 1799: * 20. Validate VMI: po_asl_attributes

1795: * 17. Validate Distribution Account
1796: *(if dist account id is not null or if null,should be an asset item/sub)
1797: *18. Validate transaction UOM
1798: *19. Validate cost_group, Xfr cost Groups
1799: * 20. Validate VMI: po_asl_attributes
1800: * 21. Validate LPN, Xfr LPN, Contenet LPN
1801: * All Other validations will be by-passed
1802: ******************************************************************/
1803: PROCEDURE validate_group(

Line 3647: 'using_organization_code' is set to -1 in the table, 'po_asl_attributes' if

3643: loaderrmsg('INV_INT_PLANORG','INV_INT_PLANORG');
3644:
3645: /*Bug#4951558. In the where clause of the below UPDATE statement, added the
3646: condition, 'paa.using_organization_code = -1' because
3647: 'using_organization_code' is set to -1 in the table, 'po_asl_attributes' if
3648: the global flag is set to 'Yes' in the ASL for an (item, supplier)
3649: combination*/
3650:
3651: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

Line 3667: FROM po_asl_attributes paa

3663: AND planning_tp_type = 1
3664: AND planning_organization_id <> ORGANIZATION_ID
3665: AND NOT EXISTS (
3666: SELECT NULL
3667: FROM po_asl_attributes paa
3668: WHERE PAA.vendor_site_id = mti.planning_organization_id
3669: AND PAA.ITEM_ID = MTI.INVENTORY_ITEM_ID
3670: AND (paa.using_organization_id = -1 OR
3671: paa.using_organization_id = mti.organization_id));