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.PO_ATTRIBUTE_VALUES_PVT dependencies on PO_LINES_ALL

Line 91: FROM PO_LINES_ALL POL,

87: )
88: IS
89: SELECT PAII.interface_line_number,
90: PAV.*
91: FROM PO_LINES_ALL POL,
92: PO_ATTRIBUTE_VALUES PAV,
93: PON_AUC_ITEMS_INTERFACE PAII
94: WHERE POL.po_header_id = p_po_header_id
95: AND POL.po_line_id = pav.po_line_id

Line 110: FROM PO_LINES_ALL POL,

106: )
107: IS
108: SELECT PAII.interface_line_number,
109: PAVT.*
110: FROM PO_LINES_ALL POL,
111: PO_ATTRIBUTE_VALUES_TLP PAVT,
112: PON_AUC_ITEMS_INTERFACE PAII
113: WHERE POL.po_header_id = p_po_header_id
114: AND POL.po_line_id = pavt.po_line_id

Line 138: PO_LINES_ALL POL

134: AND PRL.blanket_po_header_id IS NOT NULL
135: AND PRL.blanket_po_line_num IS NOT NULL
136: GROUP BY PB.auction_header_id,PB.line_number, blanket_po_header_id, blanket_po_line_num) PBR,
137: PO_ATTRIBUTE_VALUES PAV,
138: PO_LINES_ALL POL
139: WHERE PAIP.auction_header_id = PBR.auction_header_id
140: AND PAIP.line_number = PBR.line_number
141: AND POL.po_header_id = PBR.blanket_po_header_id
142: AND POL.line_num = PBR.blanket_po_line_num

Line 165: PO_LINES_ALL POL

161: AND PRL.blanket_po_header_id IS NOT NULL
162: AND PRL.blanket_po_line_num IS NOT NULL
163: GROUP BY PB.auction_header_id,PB.line_number, blanket_po_header_id, blanket_po_line_num) PBR,
164: PO_ATTRIBUTE_VALUES_TLP PAVT,
165: PO_LINES_ALL POL
166: WHERE PAIP.auction_header_id = PBR.auction_header_id
167: AND PAIP.line_number = PBR.line_number
168: AND POL.po_header_id = PBR.blanket_po_header_id
169: AND POL.line_num = PBR.blanket_po_line_num

Line 2835: PO_LINES_ALL POL,

2831: )
2832: SELECT l_key,
2833: TLP.attribute_values_tlp_id
2834: FROM PO_ATTRIBUTE_VALUES_TLP TLP,
2835: PO_LINES_ALL POL,
2836: PO_HEADERS_ALL POH
2837: WHERE TLP.po_line_id = p_po_line_id_list(i)
2838: AND p_po_line_id_list(i) <> g_NOT_REQUIRED_ID
2839: AND POL.po_line_id = TLP.po_line_id

Line 2904: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL

2900: p_default_lang_tlp_id_list IN PO_TBL_NUMBER DEFAULT NULL,
2901: p_po_line_id_list IN PO_TBL_NUMBER DEFAULT NULL,
2902: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,
2903: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,
2904: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
2905: )
2906: IS
2907: d_mod CONSTANT VARCHAR2(100) := D_create_translations;
2908: l_progress VARCHAR2(4);

Line 3434: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

3430: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
3431: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3432: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3433: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3434: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3435: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3436: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3437: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
3438: -- Bug 7039409: Added new param p_manufacturer

Line 3435: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

3431: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3432: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3433: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3434: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3435: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3436: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3437: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
3438: -- Bug 7039409: Added new param p_manufacturer
3439: p_manufacturer IN PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE

Line 3436: p_org_id IN PO_LINES_ALL.org_id%TYPE,

3432: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3433: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3434: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3435: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3436: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3437: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
3438: -- Bug 7039409: Added new param p_manufacturer
3439: p_manufacturer IN PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE
3440: )

Line 3471: PO_LINES_ALL POL

3467: -- SQL Join: po_line_id, po_header_id
3468: SELECT POH.created_language
3469: INTO l_default_lang
3470: FROM PO_HEADERS_ALL POH,
3471: PO_LINES_ALL POL
3472: WHERE POH.po_header_id = POL.po_header_id
3473: AND POL.po_line_id = p_po_line_id;
3474: ELSE
3475: l_progress := '030';

Line 3600: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

3596: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
3597: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3598: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3599: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3600: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3601: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3602: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3603: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
3604: )

Line 3601: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

3597: p_po_line_id IN PO_LINES.po_line_id%TYPE,
3598: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3599: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3600: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3601: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3602: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3603: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
3604: )
3605: IS

Line 3602: p_org_id IN PO_LINES_ALL.org_id%TYPE,

3598: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
3599: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
3600: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3601: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3602: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3603: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
3604: )
3605: IS
3606: d_mod CONSTANT VARCHAR2(100) := D_create_default_attributes;

Line 3638: PO_LINES_ALL POL

3634: -- SQL Join: po_line_id
3635: SELECT POH.type_lookup_code
3636: INTO l_type_lookup_code
3637: FROM PO_HEADERS_ALL POH,
3638: PO_LINES_ALL POL
3639: WHERE POL.po_line_id = p_po_line_id
3640: AND POH.po_header_id = POL.po_header_id;
3641: ELSE
3642: l_type_lookup_code := p_doc_type;

Line 3742: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

3738: END create_default_attributes;
3739:
3740: PROCEDURE create_default_attributes_MI
3741: (
3742: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3743: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3744: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3745: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
3746: p_organization_id IN NUMBER,

Line 3743: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

3739:
3740: PROCEDURE create_default_attributes_MI
3741: (
3742: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3743: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3744: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3745: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
3746: p_organization_id IN NUMBER,
3747: p_master_organization_id IN NUMBER

Line 3744: p_org_id IN PO_LINES_ALL.org_id%TYPE,

3740: PROCEDURE create_default_attributes_MI
3741: (
3742: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3743: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
3744: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3745: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
3746: p_organization_id IN NUMBER,
3747: p_master_organization_id IN NUMBER
3748: )

Line 3873: p_org_id IN PO_LINES_ALL.org_id%TYPE,

3869: -- this is for master items
3870:
3871: PROCEDURE wipeout_category_attributes_MI
3872: (
3873: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3874: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3875: p_inventory_item_id IN PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE,
3876: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
3877: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE

Line 3874: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

3870:
3871: PROCEDURE wipeout_category_attributes_MI
3872: (
3873: p_org_id IN PO_LINES_ALL.org_id%TYPE,
3874: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
3875: p_inventory_item_id IN PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE,
3876: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
3877: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
3878: )

Line 4104: p_org_id IN PO_LINES_ALL.org_id%TYPE,

4100:
4101: -- update attributes for master items
4102: PROCEDURE update_attributes_MI
4103: (
4104: p_org_id IN PO_LINES_ALL.org_id%TYPE,
4105: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
4106: p_inventory_item_id IN PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE,
4107: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
4108: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,

Line 4105: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

4101: -- update attributes for master items
4102: PROCEDURE update_attributes_MI
4103: (
4104: p_org_id IN PO_LINES_ALL.org_id%TYPE,
4105: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
4106: p_inventory_item_id IN PO_ATTRIBUTE_VALUES_TLP.inventory_item_id%TYPE,
4107: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
4108: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
4109: p_long_description IN PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE,

Line 4118: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;

4114: d_mod CONSTANT VARCHAR2(100) := D_update_attributes||'_MI';
4115: l_progress VARCHAR2(4);
4116:
4117: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
4118: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
4119: l_orig_item_description PO_ATTRIBUTE_VALUES_TLP.description%TYPE;
4120: l_manufacturer_part_num PO_ATTRIBUTE_VALUES.MANUFACTURER_PART_NUM%TYPE;
4121: l_orig_long_desc PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE;
4122: l_new_long_description PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE := nvl(p_long_description,' ');

Line 4126: l_inventory_org_id PO_LINES_ALL.org_id%TYPE;

4122: l_new_long_description PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE := nvl(p_long_description,' ');
4123: l_manufacturer PO_ATTRIBUTE_VALUES_TLP.MANUFACTURER%TYPE;
4124: l_proc_lead_time PO_ATTRIBUTE_VALUES.LEAD_TIME%TYPE;
4125: l_orig_manufacturer PO_ATTRIBUTE_VALUES_TLP.MANUFACTURER%TYPE;
4126: l_inventory_org_id PO_LINES_ALL.org_id%TYPE;
4127: l_rec_tlp_for_lang VARCHAR2(100);
4128:
4129: BEGIN
4130: l_progress := '010';

Line 4770: p_org_id IN PO_LINES_ALL.org_id%TYPE,

4766: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
4767: p_po_line_id IN PO_LINES.po_line_id%TYPE,
4768: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
4769: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
4770: p_org_id IN PO_LINES_ALL.org_id%TYPE,
4771: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
4772: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
4773: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
4774: )

Line 4771: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

4767: p_po_line_id IN PO_LINES.po_line_id%TYPE,
4768: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE,
4769: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE,
4770: p_org_id IN PO_LINES_ALL.org_id%TYPE,
4771: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
4772: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
4773: p_item_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE
4774: )
4775: IS

Line 4780: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;

4776: d_mod CONSTANT VARCHAR2(100) := D_update_attributes;
4777: l_progress VARCHAR2(4);
4778:
4779: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
4780: l_orig_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
4781: l_orig_item_description PO_ATTRIBUTE_VALUES_TLP.description%TYPE;
4782: BEGIN
4783: l_progress := '010';
4784:

Line 4805: PO_LINES_ALL POL

4801: -- SQL Join: po_line_id
4802: SELECT POH.type_lookup_code
4803: INTO l_type_lookup_code
4804: FROM PO_HEADERS_ALL POH,
4805: PO_LINES_ALL POL
4806: WHERE POL.po_line_id = p_po_line_id
4807: AND POH.po_header_id = POL.po_header_id;
4808: ELSE
4809: l_type_lookup_code := p_doc_type;

Line 6112: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL

6108: p_doc_type IN VARCHAR2, -- 'BLANKET', 'QUOTATION', 'REQ_TEMPLATE'
6109: p_po_line_id IN PO_LINES.po_line_id%TYPE DEFAULT NULL,
6110: p_req_template_name IN PO_REQEXPRESS_LINES_ALL.express_name%TYPE DEFAULT NULL,
6111: p_req_template_line_num IN PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE DEFAULT NULL,
6112: p_org_id IN PO_LINES_ALL.org_id%TYPE DEFAULT NULL
6113: )
6114: IS
6115: d_mod CONSTANT VARCHAR2(100) := D_delete_attributes;
6116: l_progress VARCHAR2(4);

Line 6206: FROM PO_LINES_ALL POL

6202: -- SQL Join: po_line_id, po_header_id
6203: DELETE FROM PO_ATTRIBUTE_VALUES POATR
6204: WHERE EXISTS
6205: (SELECT 'All PO Lines for the given Header'
6206: FROM PO_LINES_ALL POL
6207: WHERE POL.po_header_id = p_po_header_id
6208: AND POATR.po_line_id = POL.po_line_id);
6209:
6210:

Line 6220: FROM PO_LINES_ALL POL

6216: -- SQL Join: po_line_id, po_header_id
6217: DELETE FROM PO_ATTRIBUTE_VALUES_TLP POTLP
6218: WHERE EXISTS
6219: (SELECT 'All PO Lines for the given Header'
6220: FROM PO_LINES_ALL POL
6221: WHERE POL.po_header_id = p_po_header_id
6222: AND POTLP.po_line_id = POL.po_line_id);
6223:
6224: l_progress := '030';

Line 6288: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

6284: END get_base_lang;
6285:
6286: PROCEDURE create_attributes_tlp_MI
6287: (
6288: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6289: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
6290: p_org_id IN PO_LINES_ALL.org_id%TYPE,
6291: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
6292: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,

Line 6289: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,

6285:
6286: PROCEDURE create_attributes_tlp_MI
6287: (
6288: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6289: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
6290: p_org_id IN PO_LINES_ALL.org_id%TYPE,
6291: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
6292: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
6293: p_long_description IN PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE,

Line 6290: p_org_id IN PO_LINES_ALL.org_id%TYPE,

6286: PROCEDURE create_attributes_tlp_MI
6287: (
6288: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6289: p_ip_category_id IN PO_LINES_ALL.ip_category_id%TYPE,
6290: p_org_id IN PO_LINES_ALL.org_id%TYPE,
6291: p_language IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
6292: p_description IN PO_ATTRIBUTE_VALUES_TLP.description%TYPE,
6293: p_long_description IN PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE,
6294: p_organization_id IN NUMBER,

Line 6437: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

6433: --End of Comments
6434: --------------------------------------------------------------------------------
6435: PROCEDURE get_item_attributes_values
6436: (
6437: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6438: p_manufacturer_part_num OUT NOCOPY PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE,
6439: p_manufacturer OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE,
6440: p_lead_time OUT NOCOPY PO_ATTRIBUTE_VALUES.lead_time%TYPE
6441: )

Line 6474: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

6470: --End of Comments
6471: --------------------------------------------------------------------------------
6472: PROCEDURE get_item_attributes_values
6473: (
6474: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6475: p_manufacturer_part_num OUT NOCOPY PO_ATTRIBUTE_VALUES.manufacturer_part_num%TYPE,
6476: p_manufacturer OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.manufacturer%TYPE,
6477: p_lead_time OUT NOCOPY PO_ATTRIBUTE_VALUES.lead_time%TYPE,
6478: p_manufacturer_id OUT NOCOPY po_requisition_lines_All.MANUFACTURER_ID%TYPE

Line 6572: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,

6568: --End of Comments
6569: --------------------------------------------------------------------------------
6570: PROCEDURE get_item_attributes_tlp_values
6571: (
6572: p_inventory_item_id IN PO_LINES_ALL.item_id%TYPE,
6573: p_lang IN PO_ATTRIBUTE_VALUES_TLP.language%TYPE,
6574: p_long_description OUT NOCOPY PO_ATTRIBUTE_VALUES_TLP.long_description%TYPE
6575: )
6576: IS

Line 6579: l_master_organization_id PO_LINES_ALL.org_id%TYPE;

6575: )
6576: IS
6577: d_mod CONSTANT VARCHAR2(100) := D_get_item_attributes_tlp;
6578: l_progress VARCHAR2(4);
6579: l_master_organization_id PO_LINES_ALL.org_id%TYPE;
6580: BEGIN
6581: l_progress := '010';
6582: IF PO_LOG.d_proc THEN
6583: PO_LOG.proc_begin(d_mod,'p_inventory_item_id',p_inventory_item_id);