DBA Data[Home] [Help]

APPS.PO_SUBINVENTORIES_S dependencies on MTL_ITEM_SUB_DEFAULTS

Line 435: FROM mtl_item_sub_defaults mis,

431: X_progress := '020';
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

Line 516: x_dest_sub_name mtl_item_sub_defaults.subinventory_code%type;

512: ) IS
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

Line 580: FROM mtl_item_sub_defaults

576: x_progress := '030';
577:
578: SELECT subinventory_code
579: INTO x_dest_sub_name
580: FROM mtl_item_sub_defaults
581: WHERE inventory_item_id = x_item_id
582: AND organization_id = x_destination_organization_id
583: AND default_type = 2;
584: