eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_ASSIGNMENT_PVT dependencies on FND_NUMBER

Line 55: fnd_number.canonical_to_number(p_pk1_value)

51: CURSOR obj3 IS -- org / opposing org
52: SELECT mp.organization_code
53: FROM mtl_parameters mp
54: WHERE mp.organization_id =
55: fnd_number.canonical_to_number(p_pk1_value)
56: ;
57: --
58: CURSOR obj4 IS -- item
59: SELECT msik.concatenated_segments

Line 61: WHERE msik.organization_id = fnd_number.canonical_to_number(p_pk1_value)

57: --
58: CURSOR obj4 IS -- item
59: SELECT msik.concatenated_segments
60: FROM mtl_system_items_kfv msik
61: WHERE msik.organization_id = fnd_number.canonical_to_number(p_pk1_value)
62: AND msik.inventory_item_id = fnd_number.canonical_to_number(p_pk2_value)
63: ;
64: --
65: CURSOR obj7 IS -- sub

Line 62: AND msik.inventory_item_id = fnd_number.canonical_to_number(p_pk2_value)

58: CURSOR obj4 IS -- item
59: SELECT msik.concatenated_segments
60: FROM mtl_system_items_kfv msik
61: WHERE msik.organization_id = fnd_number.canonical_to_number(p_pk1_value)
62: AND msik.inventory_item_id = fnd_number.canonical_to_number(p_pk2_value)
63: ;
64: --
65: CURSOR obj7 IS -- sub
66: SELECT msi.secondary_inventory_name

Line 68: WHERE msi.organization_id = fnd_number.canonical_to_number(p_pk1_value)

64: --
65: CURSOR obj7 IS -- sub
66: SELECT msi.secondary_inventory_name
67: FROM mtl_secondary_inventories msi
68: WHERE msi.organization_id = fnd_number.canonical_to_number(p_pk1_value)
69: AND msi.secondary_inventory_name = p_pk2_value
70: ;
71: --
72: CURSOR obj9 IS -- item-sub

Line 78: AND msik.organization_id = fnd_number.canonical_to_number(p_pk1_value)

74: FROM mtl_system_items_kfv msik
75: ,mtl_secondary_inventories msi
76: WHERE msi.organization_id = msik.organization_id
77: AND msi.secondary_inventory_name = p_pk3_value
78: AND msik.organization_id = fnd_number.canonical_to_number(p_pk1_value)
79: AND msik.inventory_item_id = fnd_number.canonical_to_number(p_pk2_value)
80: ;
81: --
82: CURSOR obj11 IS -- txn source type

Line 79: AND msik.inventory_item_id = fnd_number.canonical_to_number(p_pk2_value)

75: ,mtl_secondary_inventories msi
76: WHERE msi.organization_id = msik.organization_id
77: AND msi.secondary_inventory_name = p_pk3_value
78: AND msik.organization_id = fnd_number.canonical_to_number(p_pk1_value)
79: AND msik.inventory_item_id = fnd_number.canonical_to_number(p_pk2_value)
80: ;
81: --
82: CURSOR obj11 IS -- txn source type
83: SELECT mtst.transaction_source_type_name

Line 85: WHERE mtst.transaction_source_type_id = fnd_number.canonical_to_number(p_pk1_value)

81: --
82: CURSOR obj11 IS -- txn source type
83: SELECT mtst.transaction_source_type_name
84: FROM mtl_txn_source_types mtst
85: WHERE mtst.transaction_source_type_id = fnd_number.canonical_to_number(p_pk1_value)
86: ;
87: --
88: CURSOR obj12 IS -- txn type
89: SELECT mtt.transaction_type_name

Line 91: WHERE mtt.transaction_type_id = fnd_number.canonical_to_number(p_pk1_value)

87: --
88: CURSOR obj12 IS -- txn type
89: SELECT mtt.transaction_type_name
90: FROM mtl_transaction_types mtt
91: WHERE mtt.transaction_type_id = fnd_number.canonical_to_number(p_pk1_value)
92: ;
93: --
94: CURSOR obj13 IS -- source project
95: SELECT ppa.segment1

Line 97: WHERE ppa.project_id = fnd_number.canonical_to_number(p_pk1_value)

93: --
94: CURSOR obj13 IS -- source project
95: SELECT ppa.segment1
96: FROM pa_projects_all ppa
97: WHERE ppa.project_id = fnd_number.canonical_to_number(p_pk1_value)
98: ;
99: --
100: CURSOR obj14 IS -- source task
101: SELECT ppa.segment1||' / '||pt.task_number

Line 104: where pt.task_id = fnd_number.canonical_to_number(p_pk1_value)

100: CURSOR obj14 IS -- source task
101: SELECT ppa.segment1||' / '||pt.task_number
102: FROM pa_projects_all ppa
103: ,pa_tasks pt
104: where pt.task_id = fnd_number.canonical_to_number(p_pk1_value)
105: and ppa.project_id = pt.project_id
106: ;
107: --
108: CURSOR obj15 IS -- txn reason

Line 111: WHERE mtr.reason_id = fnd_number.canonical_to_number(p_pk1_value)

107: --
108: CURSOR obj15 IS -- txn reason
109: SELECT mtr.reason_name
110: FROM mtl_transaction_reasons mtr
111: WHERE mtr.reason_id = fnd_number.canonical_to_number(p_pk1_value)
112: ;
113: --
114: CURSOR obj16 IS -- user
115: SELECT fu.user_name

Line 117: WHERE fu.user_id = fnd_number.canonical_to_number(p_pk1_value)

113: --
114: CURSOR obj16 IS -- user
115: SELECT fu.user_name
116: FROM fnd_user fu
117: WHERE fu.user_id = fnd_number.canonical_to_number(p_pk1_value)
118: ;
119: --
120: CURSOR obj17 IS -- txn action
121: SELECT ml.meaning

Line 124: AND ml.lookup_code = fnd_number.canonical_to_number(p_pk1_value)

120: CURSOR obj17 IS -- txn action
121: SELECT ml.meaning
122: FROM mfg_lookups ml
123: WHERE ml.lookup_type = 'MTL_TRANSACTION_ACTION'
124: AND ml.lookup_code = fnd_number.canonical_to_number(p_pk1_value)
125: ;
126: --
127: CURSOR obj19 IS -- opposing sub
128: SELECT mp.organization_code||' / '||msi.secondary_inventory_name

Line 131: WHERE msi.organization_id = fnd_number.canonical_to_number(p_pk1_value)

127: CURSOR obj19 IS -- opposing sub
128: SELECT mp.organization_code||' / '||msi.secondary_inventory_name
129: FROM mtl_parameters mp
130: ,mtl_secondary_inventories msi
131: WHERE msi.organization_id = fnd_number.canonical_to_number(p_pk1_value)
132: AND msi.secondary_inventory_name = p_pk2_value
133: AND mp.organization_id = msi.organization_id
134: ;
135: --

Line 151: WHERE ofv.organization_id = fnd_number.canonical_to_number(p_pk1_value)

147: --
148: CURSOR obj23 IS -- freight carrier
149: SELECT ofv.freight_code_tl
150: FROM org_freight ofv
151: WHERE ofv.organization_id = fnd_number.canonical_to_number(p_pk1_value)
152: AND ofv.freight_code = p_pk2_value
153: ;
154: --
155: CURSOR obj52 IS -- cat set / cat

Line 159: WHERE mcs.category_set_id = fnd_number.canonical_to_number(p_pk2_value)

155: CURSOR obj52 IS -- cat set / cat
156: SELECT mcs.category_set_name ||' / '||mck.concatenated_segments
157: FROM mtl_categories_kfv mck
158: ,mtl_category_sets_vl mcs
159: WHERE mcs.category_set_id = fnd_number.canonical_to_number(p_pk2_value)
160: AND mck.category_id = fnd_number.canonical_to_number(p_pk3_value)
161: ;
162: --
163: CURSOR obj55 IS -- ABC group / class

Line 160: AND mck.category_id = fnd_number.canonical_to_number(p_pk3_value)

156: SELECT mcs.category_set_name ||' / '||mck.concatenated_segments
157: FROM mtl_categories_kfv mck
158: ,mtl_category_sets_vl mcs
159: WHERE mcs.category_set_id = fnd_number.canonical_to_number(p_pk2_value)
160: AND mck.category_id = fnd_number.canonical_to_number(p_pk3_value)
161: ;
162: --
163: CURSOR obj55 IS -- ABC group / class
164: SELECT maag.assignment_group_name||' / '||mac.abc_class_name

Line 167: WHERE mac.abc_class_id = fnd_number.canonical_to_number(p_pk2_value)

163: CURSOR obj55 IS -- ABC group / class
164: SELECT maag.assignment_group_name||' / '||mac.abc_class_name
165: FROM mtl_abc_classes mac
166: ,mtl_abc_assignment_groups maag
167: WHERE mac.abc_class_id = fnd_number.canonical_to_number(p_pk2_value)
168: AND maag.assignment_group_id = fnd_number.canonical_to_number(p_pk1_value)
169: ;
170: --Bug4579790
171: CURSOR obj30 IS ---Customer

Line 168: AND maag.assignment_group_id = fnd_number.canonical_to_number(p_pk1_value)

164: SELECT maag.assignment_group_name||' / '||mac.abc_class_name
165: FROM mtl_abc_classes mac
166: ,mtl_abc_assignment_groups maag
167: WHERE mac.abc_class_id = fnd_number.canonical_to_number(p_pk2_value)
168: AND maag.assignment_group_id = fnd_number.canonical_to_number(p_pk1_value)
169: ;
170: --Bug4579790
171: CURSOR obj30 IS ---Customer
172: SELECT party.party_name --rc.customer_name

Line 175: WHERE party.party_id = fnd_number.canonical_to_number(p_pk1_value)

171: CURSOR obj30 IS ---Customer
172: SELECT party.party_name --rc.customer_name
173: FROM hz_parties party
174: ,hz_cust_accounts cust_acct --ra_customers rc
175: WHERE party.party_id = fnd_number.canonical_to_number(p_pk1_value)
176: AND cust_acct.party_id = party.party_id;
177: --
178: CURSOR obj56 IS ---Item Type
179: SELECT ml.meaning

Line 188: WHERE ottv.transaction_type_id = fnd_number.canonical_to_number(p_pk1_value);

184: --
185: CURSOR obj1005 IS ---Order Type
186: SELECT ottv.name
187: FROM oe_transaction_types_vl ottv
188: WHERE ottv.transaction_type_id = fnd_number.canonical_to_number(p_pk1_value);
189:
190: CURSOR obj100 IS
191: SELECT VENDOR_NAME
192: FROM PO_VENDORS

Line 193: WHERE vendor_id = fnd_number.canonical_to_number(p_pk1_value);

189:
190: CURSOR obj100 IS
191: SELECT VENDOR_NAME
192: FROM PO_VENDORS
193: WHERE vendor_id = fnd_number.canonical_to_number(p_pk1_value);
194:
195:
196: BEGIN
197: -- validate input parameters