APPS.PO_SUBINVENTORIES_S dependencies on MTL_SECONDARY_INVENTORIES

Line 62: FROM MTL_SECONDARY_INVENTORIES

58:
59: x_progress := '010';
60: SELECT 'sub_valid'
61: INTO x_status
62: FROM MTL_SECONDARY_INVENTORIES
63: WHERE SECONDARY_INVENTORY_NAME = x_subinventory
64: AND ORGANIZATION_ID = x_organization_id
65: AND NVL(DISABLE_DATE, x_transaction_date+1) > x_transaction_date;
66:

Line 294: FROM mtl_secondary_inventories

290:
291: x_progress := '010';
292: SELECT locator_type
293: INTO x_locator
294: FROM mtl_secondary_inventories
295: WHERE organization_id = x_organization_id
296: AND secondary_inventory_name = x_subinventory;
297:
298: /* debug- what if x_locator <>5, set error some how. talk to vasant */

Line 371: FROM mtl_secondary_inventories

367:
368: x_progress := '010';
369: SELECT locator_type
370: INTO x_locator
371: FROM mtl_secondary_inventories
372: WHERE organization_id = x_organization_id
373: AND secondary_inventory_name = x_subinventory;
374:
375: /* debug- what if x_locator <>5, set error some how. talk to vasant */

Line 436: mtl_secondary_inventories msi

432:
433: SELECT mis.subinventory_code
434: INTO x_subinventory
435: FROM mtl_item_sub_defaults mis,
436: mtl_secondary_inventories msi
437: WHERE mis.inventory_item_id = x_item_id
438: AND mis.organization_id = x_organization_id
439: AND mis.default_type = 2
440: AND mis.organization_id = msi.organization_id

Line 517: x_sub_type mtl_secondary_inventories.asset_inventory%type;

513:
514: x_asset_flag mtl_system_items.inventory_asset_flag%type;
515: x_intransit_type mtl_interorg_parameters.intransit_type%type;
516: x_dest_sub_name mtl_item_sub_defaults.subinventory_code%type;
517: x_sub_type mtl_secondary_inventories.asset_inventory%type;
518: x_progress VARCHAR2(3) := NULL;
519:
520: BEGIN
521:

Line 600: FROM mtl_secondary_inventories

596: x_progress := '040';
597:
598: SELECT asset_inventory
599: INTO x_sub_type
600: FROM mtl_secondary_inventories
601: WHERE organization_id = x_destination_organization_id
602: AND secondary_inventory_name = x_dest_sub_name;
603:
604:

Line 711: FROM mtl_secondary_inventories msub

707: */
708:
709: SELECT count(1)
710: INTO x_count
711: FROM mtl_secondary_inventories msub
712: WHERE msub.organization_id = x_src_org_id
713: AND msub.secondary_inventory_name = x_src_sub
714: AND trunc(sysdate) < nvl(disable_date, trunc(sysdate + 1))
715: AND msub.quantity_tracked = 1;

Line 788: FROM mtl_secondary_inventories msi

784: x_progress := '050';
785:
786: SELECT count(1)
787: INTO x_count
788: FROM mtl_secondary_inventories msi
789: WHERE msi.secondary_inventory_name = x_src_sub
790: AND msi.asset_inventory = 2;
791:
792: IF (x_count = 1) THEN

Line 818: FROM mtl_secondary_inventories msi

814: x_progress := '070';
815:
816: SELECT count(1)
817: INTO x_count
818: FROM mtl_secondary_inventories msi
819: WHERE msi.secondary_inventory_name = x_src_sub
820: AND msi.asset_inventory = 2;
821:
822: IF (x_count = 1) THEN

Line 913: FROM mtl_secondary_inventories msi

909: /* get the asset inventory column for the subinventory */
910:
911: SELECT msi.asset_inventory
912: INTO x_asset_inventory
913: FROM mtl_secondary_inventories msi
914: WHERE msi.organization_id = x_organization_id
915: AND msi.secondary_inventory_name = x_subinventory;
916:
917: