APPS.CTO_UTILITY_PK dependencies on FND_ATTACHED_DOCUMENTS

Line 3945: from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_tl fdt

3941: x_return_status := fnd_api.g_ret_sts_success;
3942:
3943: -- get the file attachment locator (blob)
3944: select fl.file_data into l_blob_loc
3945: from fnd_lobs fl, fnd_attached_documents fad, fnd_documents_tl fdt
3946: where fad.pk1_value = to_char(p_po_val_org_id)
3947: and fad.pk2_value = to_char(p_item_id)
3948: and fad.entity_name = 'MTL_SYSTEM_ITEMS'
3949: and fad.pk3_value = 'CTO:BOM:ATTACHMENT'

Line 4123: from fnd_attached_documents

4119: l_stmt := 30;
4120:
4121: select (nvl(max(seq_num),0) + 10)
4122: into l_seq_num
4123: from fnd_attached_documents
4124: where entity_name = 'MTL_SYSTEM_ITEMS'
4125: and pk1_value = to_char(p_org_id) -- 2774570
4126: and pk2_value = to_char(p_item_id); -- 6069512: Added to improve performance, we do not need seq to be unique across items.
4127:

Line 4130: select fnd_attached_documents_s.nextval

4126: and pk2_value = to_char(p_item_id); -- 6069512: Added to improve performance, we do not need seq to be unique across items.
4127:
4128:
4129: l_stmt := 40;
4130: select fnd_attached_documents_s.nextval
4131: into l_attached_document_id
4132: from dual;
4133:
4134: l_stmt := 50;

Line 4136: FND_ATTACHED_DOCUMENTS_PKG.INSERT_ROW

4132: from dual;
4133:
4134: l_stmt := 50;
4135:
4136: FND_ATTACHED_DOCUMENTS_PKG.INSERT_ROW
4137: (x_rowid => l_row_id
4138: , x_attached_document_id => l_attached_document_id
4139: , x_document_id => l_doc_id
4140: , x_seq_num => l_seq_num

Line 6652: FROM FND_ATTACHED_DOCUMENTS

6648:
6649: BEGIN
6650: SELECT document_id
6651: INTO l_document_id
6652: FROM FND_ATTACHED_DOCUMENTS
6653: WHERE pk1_value = to_char(config_orgs_rec.po_valid_org) -- 2774570
6654: AND pk2_value = to_char(config_items_rec.config_item_id) -- 2774570
6655: AND entity_name = 'MTL_SYSTEM_ITEMS'
6656: AND Pk3_value = 'CTO:BOM:ATTACHMENT';