APPS.CTO_DEACTIVATE_CONFIG_PK dependencies on MTL_PARAMETERS

Line 126: cfg_orgn_code mtl_parameters.organization_code%type,--5291392

122: TYPE r_cfg_item_details IS RECORD(
123: cfg_item_id mtl_system_items_kfv.inventory_item_id%type,
124: cfg_item_name mtl_system_items_kfv.concatenated_segments%type,
125: cfg_orgn_id number,
126: cfg_orgn_code mtl_parameters.organization_code%type,--5291392
127: msg VARCHAR2(200)
128: );
129:
130: --start 5291392

Line 132: org_id mtl_parameters.organization_id%type,

128: );
129:
130: --start 5291392
131: TYPE r_org_details IS RECORD(
132: org_id mtl_parameters.organization_id%type,
133: org_code mtl_parameters.organization_code%type
134: );
135:
136:

Line 133: org_code mtl_parameters.organization_code%type

129:
130: --start 5291392
131: TYPE r_org_details IS RECORD(
132: org_id mtl_parameters.organization_id%type,
133: org_code mtl_parameters.organization_code%type
134: );
135:
136:
137: TYPE t_org_details IS TABLE OF r_org_details INDEX BY BINARY_INTEGER;

Line 522: mtl_parameters mp

518: msi.concatenated_segments,
519: msi.organization_id,
520: decode(mp.organization_id, mp.master_organization_id, 2, 1) order_level
521: from mtl_system_items_kfv msi,
522: mtl_parameters mp
523: where msi.base_item_id is NOT NULL
524: and msi.inventory_item_status_code <> l_del_status
525: and msi.organization_id = mp.organization_id
526: and mp.master_organization_id = l_Org_Id

Line 539: mtl_parameters mp

535: msi.concatenated_segments,
536: msi.organization_id,
537: decode(mp.organization_id, mp.master_organization_id, 2, 1) order_level
538: from mtl_system_items_kfv msi,
539: mtl_parameters mp
540: where msi.inventory_item_status_code <> l_del_status
541: and msi.organization_id = mp.organization_id
542: and msi.inventory_item_id = l_Config_Id
543: and mp.master_organization_id = l_org_id

Line 556: mtl_parameters mp

552: msi.concatenated_segments,
553: msi.organization_id,
554: decode(mp.organization_id, mp.master_organization_id, 2, 1) order_level
555: from mtl_system_items_kfv msi,
556: mtl_parameters mp
557: where msi.base_item_id = l_Model_Id
558: and msi.inventory_item_status_code <> l_del_status
559: and msi.organization_id = mp.organization_id
560: and mp.master_organization_id = l_org_id

Line 575: mtl_parameters mp

571: msi.concatenated_segments,
572: msi.organization_id,
573: decode(mp.organization_id, mp.master_organization_id, 2, 1) order_level
574: from mtl_system_items_kfv msi,
575: mtl_parameters mp
576: where msi.base_item_id = l_Model_Id
577: and msi.inventory_item_status_code <> l_del_status
578: and msi.organization_id = mp.organization_id
579: and mp.master_organization_id = l_org_id

Line 2038: from mtl_parameters

2034: l_master_orgn_id number;
2035: begin
2036: select master_organization_id
2037: into l_master_orgn_id
2038: from mtl_parameters
2039: where organization_id = p_org_id;
2040:
2041: x_master_orgn_id := l_master_orgn_id; -- assigning to OUT parameter.
2042:

Line 2058: from mtl_parameters

2054: l_master_orgn_id number;
2055: begin
2056: select master_organization_id
2057: into l_master_orgn_id
2058: from mtl_parameters
2059: where organization_id = p_org_id;
2060:
2061: x_master_orgn_id := l_master_orgn_id; -- assigning to OUT parameter.
2062: end;

Line 2863: from mtl_parameters

2859: END IF;
2860:
2861: select organization_code
2862: INTO p_organization_code
2863: from mtl_parameters
2864: where organization_id = p_organization_id;
2865:
2866: tab_org_details(p_organization_id).org_id := p_organization_id;
2867: tab_org_details(p_organization_id).org_code := p_organization_code;