[Home] [Help]
PACKAGE: APPS.INV_MWB_QUERY_MANAGER
Source
1 PACKAGE INV_MWB_QUERY_MANAGER AS
2 /* $Header: INVMWQMS.pls 120.16 2008/01/10 23:57:24 musinha ship $ */
3 TYPE SelectColumnRecType IS RECORD ( column_name VARCHAR2(100), column_value VARCHAR2(100) );
4
5 TYPE SelectColumnTabType IS TABLE OF SelectColumnRecType INDEX BY BINARY_INTEGER;
6
7 -- Bug 6060233: Changed the size to 500
8 TYPE SQLClauseTabType IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER; -- Bug 6429880
9
10
11 g_onhand_select SelectColumnTabType;
12 g_onhand_from SQLClauseTabType;
13 g_onhand_where SQLClauseTabType;
14 g_onhand_group SQLClauseTabType;
15
16 g_onhand_1_select SelectColumnTabType;
17 g_onhand_1_from SQLClauseTabType;
18 g_onhand_1_where SQLClauseTabType;
19 g_onhand_1_group SQLClauseTabType;
20
21 g_inbound_select SelectColumnTabType;
22 g_inbound_from SQLClauseTabType;
23 g_inbound_where SQLClauseTabType;
24 g_inbound_group SQLClauseTabType;
25
26 g_inbound_1_select SelectColumnTabType;
27 g_inbound_1_from SQLClauseTabType;
28 g_inbound_1_where SQLClauseTabType;
29 g_inbound_1_group SQLClauseTabType;
30
31 g_receiving_select SelectColumnTabType;
32 g_receiving_from SQLClauseTabType;
33 g_receiving_where SQLClauseTabType;
34 g_receiving_group SQLClauseTabType;
35
36 g_receiving_1_select SelectColumnTabType;
37 g_receiving_1_from SQLClauseTabType;
38 g_receiving_1_where SQLClauseTabType;
39 g_receiving_1_group SQLClauseTabType;
40
41 g_union_select SelectColumnTabType;
42 g_union_from SQLClauseTabType;
43 g_union_where SQLClauseTabType;
44 g_union_group SQLClauseTabType;
45
46 g_null_select SelectColumnTabType;
47 g_null_clause SQLClauseTabType;
48
49
50 PROCEDURE add_from_clause(p_from_clause IN VARCHAR2, p_target IN VARCHAR2);
51 PROCEDURE add_where_clause(p_where_clause IN VARCHAR2, p_target IN VARCHAR2);
52 PROCEDURE add_group_clause(p_group_clause IN VARCHAR2, p_target IN VARCHAR2);
53 PROCEDURE add_bind_variable(p_bind_name IN VARCHAR2, p_bind_value IN VARCHAR2);
54 PROCEDURE add_bind_variable(p_bind_name IN VARCHAR2, p_bind_value IN DATE);
55 PROCEDURE add_bind_variable(p_bind_name IN VARCHAR2, p_bind_value IN NUMBER);
56 PROCEDURE add_qf_where_onhand(p_flag VARCHAR2);
57 PROCEDURE add_qf_where_receiving(p_flag VARCHAR2);
58 PROCEDURE add_qf_where_inbound(p_flag VARCHAR2);
59 PROCEDURE add_qf_where_lpn_node(p_mat_loc VARCHAR2);
60 PROCEDURE execute_query;
61 PROCEDURE make_nested_lpn_onhand_query;
62 PROCEDURE make_nested_lpn_rcv_query;
63 PROCEDURE make_nested_lpn_inbound_query;
64
65 PROCEDURE initialize_onhand_query;
66 PROCEDURE initialize_inbound_query;
67 PROCEDURE initialize_receiving_query;
68
69 PROCEDURE initialize_onhand_1_query;
70 PROCEDURE initialize_inbound_1_query;
71 PROCEDURE initialize_receiving_1_query;
72
73 PROCEDURE initialize_union_query;
74
75 PO_RELEASE_ID CONSTANT NUMBER := 1;
76 RELEASE_LINE_NUMBER CONSTANT NUMBER := 2;
77 SHIPMENT_NUMBER CONSTANT NUMBER := 3;
78 SHIPMENT_HEADER_ID_INTERORG CONSTANT NUMBER := 4;
79 ASN CONSTANT NUMBER := 5;
80 SHIPMENT_HEADER_ID_ASN CONSTANT NUMBER := 6;
81 TRADING_PARTNER CONSTANT NUMBER := 7;
82 VENDOR_ID CONSTANT NUMBER := 8;
83 TRADING_PARTNER_SITE CONSTANT NUMBER := 9;
84 VENDOR_SITE_ID CONSTANT NUMBER := 10;
85 FROM_ORG CONSTANT NUMBER := 11;
86 FROM_ORG_ID CONSTANT NUMBER := 12;
87 TO_ORG CONSTANT NUMBER := 13;
88 TO_ORG_ID CONSTANT NUMBER := 14;
89 EXPECTED_RECEIPT_DATE CONSTANT NUMBER := 15;
90 SHIPPED_DATE CONSTANT NUMBER := 16;
91 OWNING_ORG CONSTANT NUMBER := 17;
92 OWNING_ORG_ID CONSTANT NUMBER := 18;
93 REQ_HEADER_ID CONSTANT NUMBER := 19;
94 OE_HEADER_ID CONSTANT NUMBER := 20;
95 PO_HEADER_ID CONSTANT NUMBER := 21;
96 MATURITY_DATE CONSTANT NUMBER := 22;
97 HOLD_DATE CONSTANT NUMBER := 23;
98 SUPPLIER_LOT CONSTANT NUMBER := 24;
99 PARENT_LOT CONSTANT NUMBER := 25;
100 DOCUMENT_TYPE CONSTANT NUMBER := 26;
101 DOCUMENT_TYPE_ID CONSTANT NUMBER := 27;
102 DOCUMENT_NUMBER CONSTANT NUMBER := 28;
103 DOCUMENT_LINE_NUMBER CONSTANT NUMBER := 29;
104 RELEASE_NUMBER CONSTANT NUMBER := 30;
105 ORIGINATION_TYPE CONSTANT NUMBER := 31;
106 ORIGINATION_DATE CONSTANT NUMBER := 32;
107 ACTION_CODE CONSTANT NUMBER := 33;
108 ACTION_DATE CONSTANT NUMBER := 34;
109 RETEST_DATE CONSTANT NUMBER := 35;
110 SECONDARY_UNPACKED CONSTANT NUMBER := 36;
111 SECONDARY_PACKED CONSTANT NUMBER := 37;
112 SUBINVENTORY_CODE CONSTANT NUMBER := 38;
113 LOCATOR CONSTANT NUMBER := 39;
114 LOCATOR_ID CONSTANT NUMBER := 40;
115 LPN CONSTANT NUMBER := 41;
116 LPN_ID CONSTANT NUMBER := 42;
117 COST_GROUP CONSTANT NUMBER := 43;
118 CG_ID CONSTANT NUMBER := 44;
119 LOADED CONSTANT NUMBER := 45;
120 PLANNING_PARTY CONSTANT NUMBER := 46;
121 PLANNING_PARTY_ID CONSTANT NUMBER := 47;
122 OWNING_PARTY CONSTANT NUMBER := 48;
123 OWNING_PARTY_ID CONSTANT NUMBER := 49;
124 LOT CONSTANT NUMBER := 50;
125 SERIAL CONSTANT NUMBER := 51;
126 UNIT_NUMBER CONSTANT NUMBER := 52;
127 LOT_EXPIRY_DATE CONSTANT NUMBER := 53;
128 ORGANIZATION_CODE CONSTANT NUMBER := 54;
129 ORG_ID CONSTANT NUMBER := 55;
130 ITEM CONSTANT NUMBER := 56;
131 ITEM_DESCRIPTION CONSTANT NUMBER := 57;
132 ITEM_ID CONSTANT NUMBER := 58;
133 REVISION CONSTANT NUMBER := 59;
134 PRIMARY_UOM_CODE CONSTANT NUMBER := 60;
135 ONHAND CONSTANT NUMBER := 61;
136 RECEIVING CONSTANT NUMBER := 62;
137 INBOUND CONSTANT NUMBER := 63;
138 UNPACKED CONSTANT NUMBER := 64;
139 PACKED CONSTANT NUMBER := 65;
140 SECONDARY_UOM_CODE CONSTANT NUMBER := 66;
141 SECONDARY_ONHAND CONSTANT NUMBER := 67;
142 SECONDARY_RECEIVING CONSTANT NUMBER := 68;
143 SECONDARY_INBOUND CONSTANT NUMBER := 69;
144 GRADE_CODE CONSTANT NUMBER := 70;
145 OWNING_ORGANIZATION_ID CONSTANT NUMBER := 71;
146 PLANNING_ORGANIZATION_ID CONSTANT NUMBER := 72;
147 OWNING_TP_TYPE CONSTANT NUMBER := 73;
148 PLANNING_TP_TYPE CONSTANT NUMBER := 74;
149
150 -- Onhand Material Status support
151 STATUS CONSTANT NUMBER := 75;
152 STATUS_ID CONSTANT NUMBER := 76;
153
154 END INV_MWB_QUERY_MANAGER;