APPS.WMS_ASSIGNMENT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 52

	SELECT mp.organization_code
	  FROM mtl_parameters      mp
	  WHERE mp.organization_id =
	        fnd_number.canonical_to_number(p_pk1_value)
	  ;

Line: 59

	SELECT msik.concatenated_segments
	  FROM mtl_system_items_kfv   msik
	  WHERE msik.organization_id = fnd_number.canonical_to_number(p_pk1_value)
	  AND msik.inventory_item_id = fnd_number.canonical_to_number(p_pk2_value)
	  ;

Line: 66

	SELECT msi.secondary_inventory_name
	  FROM mtl_secondary_inventories    msi
	  WHERE msi.organization_id  = fnd_number.canonical_to_number(p_pk1_value)
	  AND msi.secondary_inventory_name = p_pk2_value
	  ;

Line: 73

	SELECT msik.concatenated_segments||' / '||msi.SECONDARY_INVENTORY_NAME
	  FROM mtl_system_items_kfv         msik
              ,mtl_secondary_inventories    msi
	  WHERE msi.organization_id   = msik.organization_id
	  AND msi.secondary_inventory_name = p_pk3_value
	  AND msik.organization_id    = fnd_number.canonical_to_number(p_pk1_value)
	  AND msik.inventory_item_id  = fnd_number.canonical_to_number(p_pk2_value)
	  ;

Line: 83

	SELECT mtst.transaction_source_type_name
	  FROM mtl_txn_source_types            mtst
	  WHERE mtst.transaction_source_type_id = fnd_number.canonical_to_number(p_pk1_value)
	  ;

Line: 89

	SELECT mtt.transaction_type_name
	  FROM mtl_transaction_types   mtt
	  WHERE mtt.transaction_type_id = fnd_number.canonical_to_number(p_pk1_value)
	  ;

Line: 95

	SELECT ppa.segment1
	  FROM pa_projects_all ppa
	  WHERE ppa.project_id  = fnd_number.canonical_to_number(p_pk1_value)
	  ;

Line: 101

	SELECT ppa.segment1||' / '||pt.task_number
	  FROM pa_projects_all ppa
               ,pa_tasks       pt
	  where pt.task_id     = fnd_number.canonical_to_number(p_pk1_value)
	  and ppa.project_id   = pt.project_id
	  ;

Line: 109

	SELECT  mtr.reason_name
	  FROM  mtl_transaction_reasons  mtr
	  WHERE mtr.reason_id = fnd_number.canonical_to_number(p_pk1_value)
	  ;

Line: 115

	SELECT fu.user_name
	  FROM fnd_user   fu
	  WHERE fu.user_id = fnd_number.canonical_to_number(p_pk1_value)
	  ;

Line: 121

	SELECT ml.meaning
	  FROM mfg_lookups    ml
	  WHERE ml.lookup_type = 'MTL_TRANSACTION_ACTION'
	  AND ml.lookup_code = fnd_number.canonical_to_number(p_pk1_value)
	  ;

Line: 128

	SELECT mp.organization_code||' / '||msi.secondary_inventory_name
	  FROM mtl_parameters     mp
              ,mtl_secondary_inventories   msi
	  WHERE msi.organization_id        = fnd_number.canonical_to_number(p_pk1_value)
	  AND msi.secondary_inventory_name = p_pk2_value
	  AND mp.organization_id           = msi.organization_id
	  ;

Line: 137

       SELECT muom.unit_of_measure_tl
	 FROM mtl_units_of_measure muom
	 WHERE muom.uom_code   = p_pk1_value
	 ;

Line: 143

	SELECT muc.uom_class_tl
	  FROM mtl_uom_classes muc
	  WHERE muc.uom_class   = p_pk1_value
	  ;

Line: 149

	SELECT ofv.freight_code_tl
	  FROM org_freight   ofv
	  WHERE ofv.organization_id = fnd_number.canonical_to_number(p_pk1_value)
	  AND ofv.freight_code    = p_pk2_value
	  ;

Line: 156

	SELECT mcs.category_set_name ||' / '||mck.concatenated_segments
	  FROM mtl_categories_kfv   mck
              ,mtl_category_sets_vl mcs
	 WHERE mcs.category_set_id = fnd_number.canonical_to_number(p_pk2_value)
	   AND mck.category_id     = fnd_number.canonical_to_number(p_pk3_value)
	  ;

Line: 164

	SELECT maag.assignment_group_name||' / '||mac.abc_class_name
	  FROM mtl_abc_classes           mac
	      ,mtl_abc_assignment_groups maag
	  WHERE mac.abc_class_id       = fnd_number.canonical_to_number(p_pk2_value)
	    AND maag.assignment_group_id = fnd_number.canonical_to_number(p_pk1_value)
	  ;

Line: 172

	SELECT party.party_name --rc.customer_name
	  FROM hz_parties party
	      ,hz_cust_accounts cust_acct --ra_customers rc
	  WHERE party.party_id = fnd_number.canonical_to_number(p_pk1_value)
          AND   cust_acct.party_id = party.party_id;

Line: 179

	SELECT ml.meaning
	  FROM fnd_common_lookups ml
	  WHERE ml.lookup_type = 'ITEM_TYPE'
	  AND ml.lookup_code =  rtrim(ltrim(p_pk1_value));

Line: 186

	SELECT ottv.name
	  FROM oe_transaction_types_vl ottv
	  WHERE ottv.transaction_type_id = fnd_number.canonical_to_number(p_pk1_value);

Line: 191

       SELECT VENDOR_NAME
       FROM PO_VENDORS
       WHERE vendor_id = fnd_number.canonical_to_number(p_pk1_value);