DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PVT dependencies on MTL_INTERCOMPANY_PARAMETERS

Line 1476: SELECT 1 INTO l_count FROM MTL_INTERCOMPANY_PARAMETERS

1472: if g_debug=1 then
1473: debug('The value of from_org_id is'||l_lines_table(l_index).from_org_id,'Validate_Trx_Flow_Lines');
1474: debug('The value of to_org_id is'||l_lines_table(l_index).to_org_id,'Validate_Trx_Flow_Lines');
1475: end if;
1476: SELECT 1 INTO l_count FROM MTL_INTERCOMPANY_PARAMETERS
1477: WHERE SHIP_ORGANIZATION_ID=l_lines_table(l_index).from_org_id
1478: AND SELL_ORGANIZATION_ID=l_lines_table(l_index).to_org_id
1479: AND FLOW_TYPE=p_flow_type;
1480: If l_count=1

Line 1487: select ship_organization_id from mtl_intercompany_parameters

1483: Then
1484: Begin
1485: select 1 into l_count1 from dual where exists
1486: (
1487: select ship_organization_id from mtl_intercompany_parameters
1488: where ship_organization_id=l_lines_table(l_index).from_org_id
1489: and sell_organization_id=l_lines_table(l_index).to_org_id
1490: and flow_type=p_flow_type
1491: and