14: SELECT fcc.meaning,
15: tn.meaning
16: INTO fcc_code,
17: tran_nat
18: FROM mtl_system_items mtl, fnd_lookups fcc, fnd_lookups tn
19: WHERE fcc.lookup_code = SUBSTR (mtl.global_attribute1, 1, 25)
20: AND fcc.lookup_type = fcc_code_type
21: AND tn.lookup_code = SUBSTR (mtl.global_attribute2, 1, 25)
22: AND tn.lookup_type = tran_nat_type
54: BEGIN
55: Errcd := 0;
56: SELECT global_attribute1
57: INTO fc_code
58: FROM mtl_system_items mtl
59: WHERE mtl.organization_id = form_org_id
60: AND inventory_item_id = form_item_id
61: AND rownum = row_number;
62: EXCEPTION
136: BEGIN
137: Errcd := 0;
138: SELECT global_attribute2, global_attribute1
139: INTO trx_reason, fcc
140: FROM mtl_system_items mtl
141: WHERE mtl.organization_id = org_id
142: AND mtl.inventory_item_id = item_id
143: AND rownum = row_number;
144: EXCEPTION
248: -- This procedure gets transaction reason code from po_system_parameters
249: --
250: PROCEDURE get_trx_reason_from_po(
251: p_org_id IN PO_SYSTEM_PARAMETERS.ORG_ID%TYPE,
252: p_trx_reason_code OUT NOCOPY MTL_SYSTEM_ITEMS.GLOBAL_ATTRIBUTE2%TYPE,
253: p_error_code OUT NOCOPY NUMBER)
254: IS
255:
256: CURSOR get_trx_reason_code_so_csr
302: -- get_trx_reason_cd_per_req_line
303: --
304: -- DESCRIPTION
305: -- This procedure is called from JL library, it gets the transaction
306: -- reason code from mtl_system_items based on a given item_id and the
307: -- organization that user specified from the Transaction Nature
308: -- Defaulting Rule GDF in PO Options form. If no item is provided or
309: -- Transaction Reason code is not available from mtl_system_items for
310: -- the specified Local/Master inventory organization, the
305: -- This procedure is called from JL library, it gets the transaction
306: -- reason code from mtl_system_items based on a given item_id and the
307: -- organization that user specified from the Transaction Nature
308: -- Defaulting Rule GDF in PO Options form. If no item is provided or
309: -- Transaction Reason code is not available from mtl_system_items for
310: -- the specified Local/Master inventory organization, the
311: -- Transaction Reason code from PO Options form will be returned
312:
313: PROCEDURE get_trx_reason_cd_per_req_line(
310: -- the specified Local/Master inventory organization, the
311: -- Transaction Reason code from PO Options form will be returned
312:
313: PROCEDURE get_trx_reason_cd_per_req_line(
314: p_master_inv_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
315: , p_inventory_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
316: , p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
317: , p_org_id IN PO_REQUISITION_LINES.ORG_ID%TYPE
318: , x_trx_reason_code OUT NOCOPY PO_REQUISITION_LINES.TRANSACTION_REASON_CODE%TYPE
311: -- Transaction Reason code from PO Options form will be returned
312:
313: PROCEDURE get_trx_reason_cd_per_req_line(
314: p_master_inv_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
315: , p_inventory_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
316: , p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
317: , p_org_id IN PO_REQUISITION_LINES.ORG_ID%TYPE
318: , x_trx_reason_code OUT NOCOPY PO_REQUISITION_LINES.TRANSACTION_REASON_CODE%TYPE
319: , x_error_code OUT NOCOPY NUMBER)
312:
313: PROCEDURE get_trx_reason_cd_per_req_line(
314: p_master_inv_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
315: , p_inventory_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
316: , p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
317: , p_org_id IN PO_REQUISITION_LINES.ORG_ID%TYPE
318: , x_trx_reason_code OUT NOCOPY PO_REQUISITION_LINES.TRANSACTION_REASON_CODE%TYPE
319: , x_error_code OUT NOCOPY NUMBER)
320: IS
331: x_error_code := 0;
332:
333: IF p_item_id IS NOT NULL THEN
334: --
335: -- get transaction reason code from mtl system items if
336: -- item is known.
337: -- determine which organization to use from po system parameters
338: --
339: get_trx_reason_def_rule(