APPS.INV_TXN_MANAGER_GRP dependencies on PO_ASL_ATTRIBUTES

Line 1891: * 20. Validate VMI: po_asl_attributes

1887: * 17. Validate Distribution Account
1888: *(if dist account id is not null or if null,should be an asset item/sub)
1889: *18. Validate transaction UOM
1890: *19. Validate cost_group, Xfr cost Groups
1891: * 20. Validate VMI: po_asl_attributes
1892: * 21. Validate LPN, Xfr LPN, Contenet LPN
1893: * All Other validations will be by-passed
1894: ******************************************************************/
1895: PROCEDURE validate_group(

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

3830: loaderrmsg('INV_INT_PLANORG','INV_INT_PLANORG');
3831:
3832: /*Bug#4951558. In the where clause of the below UPDATE statement, added the
3833: condition, 'paa.using_organization_code = -1' because
3834: 'using_organization_code' is set to -1 in the table, 'po_asl_attributes' if
3835: the global flag is set to 'Yes' in the ASL for an (item, supplier)
3836: combination*/
3837:
3838: UPDATE MTL_TRANSACTIONS_INTERFACE MTI

Line 3854: FROM po_asl_attributes paa

3850: AND planning_tp_type = 1
3851: AND planning_organization_id <> ORGANIZATION_ID
3852: AND NOT EXISTS (
3853: SELECT NULL
3854: FROM po_asl_attributes paa
3855: WHERE PAA.vendor_site_id = mti.planning_organization_id
3856: AND PAA.ITEM_ID = MTI.INVENTORY_ITEM_ID
3857: AND (paa.using_organization_id = -1 OR
3858: paa.using_organization_id = mti.organization_id));