DBA Data[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on MTL_INTERCOMPANY_PARAMETERS

Line 2737: FROM MTL_INTERCOMPANY_PARAMETERS

2733: LOOP
2734: shiporgs := getUniqueList(getShippingOrgsForOu(oulist(i)));
2735: SELECT COUNT(FREIGHT_CODE_COMBINATION_ID)
2736: INTO shsecnt
2737: FROM MTL_INTERCOMPANY_PARAMETERS
2738: WHERE SHIP_ORGANIZATION_ID = oulist(i)
2739: OR SELL_ORGANIZATION_ID = oulist(i);
2740: IF shsecnt <> 0 THEN
2741: SELECT COUNT(FREIGHT_CODE_COMBINATION_ID)

Line 2743: FROM MTL_INTERCOMPANY_PARAMETERS

2739: OR SELL_ORGANIZATION_ID = oulist(i);
2740: IF shsecnt <> 0 THEN
2741: SELECT COUNT(FREIGHT_CODE_COMBINATION_ID)
2742: INTO shipcnt
2743: FROM MTL_INTERCOMPANY_PARAMETERS
2744: WHERE SHIP_ORGANIZATION_ID = oulist(i);
2745: END IF;
2746: IF ( shsecnt = 0 ) OR ( shsecnt <> 0 AND shipcnt <> 0 ) THEN
2747: FOR j IN 1..shiporgs.COUNT