DBA Data[Home] [Help]

APPS.INL_INTEGRATION_GRP dependencies on MO_GLOBAL

Line 1223: AND mo_global.check_access(org_id) = 'Y'

1219: WHERE processing_status_code = 'RUNNING'
1220: AND transaction_status_code = 'PENDING'
1221: AND processing_mode_code = p_processing_mode
1222: AND group_id = nvl(p_group_id, group_id)
1223: AND mo_global.check_access(org_id) = 'Y'
1224: AND processing_mode_code = p_processing_mode
1225: AND source_document_code = 'PO'
1226: AND transaction_type NOT IN('SHIP', 'RECEIVE', 'ACCEPT', 'REJECT','TRANSFER','UNORDERED')
1227: AND lcm_shipment_line_id IS NOT NULL

Line 1247: AND mo_global.check_access(org_id) = 'Y'

1243: AND transaction_status_code = 'PENDING'
1244: AND processing_mode_code = p_processing_mode
1245: AND group_id = nvl(p_group_id, group_id)
1246: AND processing_mode_code = p_processing_mode
1247: AND mo_global.check_access(org_id) = 'Y'
1248: AND source_document_code = 'PO'
1249: AND transaction_type NOT IN('SHIP', 'RECEIVE', 'ACCEPT', 'REJECT','TRANSFER','UNORDERED')
1250: AND lcm_shipment_line_id IS NOT NULL
1251: AND lcm_shipment_line_id = p_rti_rec(i).line_id;

Line 1269: AND mo_global.check_access(org_id) = 'Y'

1265: UPDATE rcv_transactions_interface
1266: SET processing_status_code = 'ERROR'
1267: WHERE processing_status_code = 'RUNNING'
1268: AND transaction_status_code = 'PENDING'
1269: AND mo_global.check_access(org_id) = 'Y'
1270: AND processing_mode_code = p_processing_mode
1271: AND group_id = nvl(p_group_id, group_id)
1272: AND source_document_code = 'PO'
1273: AND transaction_type NOT IN ('SHIP', 'RECEIVE', 'ACCEPT', 'REJECT','TRANSFER','UNORDERED')