DBA Data[Home] [Help]

APPS.FV_AP_CANCEL_PKG dependencies on STANDARD

Line 30: decode(ph.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),

26:
27: SELECT pd.line_location_id,
28: pd.po_line_id,
29: decode(pd.po_release_id, null, pd.po_header_id, pd.po_release_id),
30: decode(ph.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),
31: decode(pd.po_release_id, NULL, ph.type_lookup_code,
32: pr.release_type),
33: MAX(aid.accounting_date)
34: INTO l_line_location_id,

Line 56: decode(ph.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),

52: AND decode(PLL.final_match_flag, 'Y', 'D', NVL(AID.final_match_flag, 'N')) = 'D' -- Bug 3706938
53: GROUP BY pd.line_location_id,
54: pd.po_line_id,
55: decode(pd.po_release_id, null, pd.po_header_id, pd.po_release_id),
56: decode(ph.type_lookup_code, 'STANDARD', 'PO', 'RELEASE'),
57: decode(pd.po_release_id, NULL, ph.type_lookup_code,
58: pr.release_type);
59:
60: IF (NOT(PO_ACTIONS.Close_PO (p_docid => l_po_header_id,