DBA Data[Home] [Help]

APPS.PO_SUBINVENTORIES_S dependencies on MTL_INTERORG_PARAMETERS

Line 515: x_intransit_type mtl_interorg_parameters.intransit_type%type;

511: x_allow_expense_source OUT NOCOPY VARCHAR2
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:

Line 555: FROM mtl_interorg_parameters

551: x_progress := '020';
552:
553: SELECT intransit_type
554: INTO x_intransit_type
555: FROM mtl_interorg_parameters
556: WHERE from_organization_id = x_source_organization_id
557: AND to_organization_id = x_destination_organization_id
558: AND x_source_organization_id <> x_destination_organization_id;
559:

Line 679: x_intransit_type mtl_interorg_parameters.intransit_type%type;

675:
676: x_progress VARCHAR2(3) := '';
677: x_count NUMBER := 0;
678: x_restrict_sub mtl_system_items.restrict_subinventories_code%type;
679: x_intransit_type mtl_interorg_parameters.intransit_type%type;
680: x_allow_expense_source VARCHAR2(1) := '';
681:
682: BEGIN
683:

Line 778: FROM mtl_interorg_parameters mip

774: x_progress := '040';
775:
776: SELECT mip.intransit_type
777: INTO x_intransit_type
778: FROM mtl_interorg_parameters mip
779: WHERE mip.from_organization_id = x_src_org_id
780: AND mip.to_organization_id = x_dest_org_id;
781:
782: IF (x_intransit_type <> 1) THEN